Following up the above ,
We can fetch the click details through MCAE API connection and download that report through SFTP server.
For the above statement we definitly need any middleware to implement the API query and see the results.
Is there any integration documentation to implement middleware to fetch API query and see the results?
@Selvasubha R there is no single Salesforce document for “MCAE API query -> generate file -> push to SFTP” because the SFTP/file-generation part is a custom middleware responsibility.
For click details, use the Account Engagement API, usually Visitor Activity. Click activities are available there, including activity type 1 for Click and 21 for Custom URL Click:
https://developer.salesforce.com/docs/marketing/pardot/guide/visitor-activity-v5.html
For larger exports, use the Account Engagement Export API instead of normal synchronous queries: https://developer.salesforce.com/docs/marketing/pardot/guide/export-v5.html
The usual architecture is: MCAE API -> middleware job -> transform response to CSV -> upload CSV to SFTP. The middleware can be MuleSoft, Boomi, Workato, Azure Function, AWS Lambda, Python/Node scheduler, etc. Salesforce will provide the API endpoints and authentication, but the SFTP upload, file naming, scheduling, retry logic, and logging need to be built in the middleware.
If this is Marketing Cloud Engagement SFTP, Salesforce documents SFTP usage here: https://help.salesforce.com/s/articleView?id=mktg.mc_overview_ftp_accounts.htm&type=5
For Account Engagement specifically, treat the API as the data source and the SFTP delivery as a custom integration layer.
