PDF Include Options and Formatting using API bulk export
Hi all,
I am successfully calling to export a dashboard from our Analytics workspace using the Analytics API from within a CRM function, however I have come across the following issues that we want to address:
- Include either:
a custom header which displays the custom report parameters (eg 'Report for 01 May 2024 to the 31 May 2024'). I have tried adding to the API URL:
/data?CONFIG=""centerHeader":5,"centerHeaderText":ReportTitle
But this is not changing anything when the PDF exports,
OR: - If I cannot achieve the above, I would like to show the report user filters in the PDF, the same as when you manually export the dashboard as a PDF from within Analytics, there is an option under 'Include' that is a checkbox 'User Filter Criteria'. I found nothing in the Analytics API documentation to say how to include this option when exporting.
- A big issue we face is: when I manually export the dashboard as a PDF all of the columns line up (they are the same width as I have designed) as they do in the reports in the dashboard, however when I do the export from the API the columns do not line up, they seem to just be preset to equal widths, so long text values wrap and the entire report looks terrible. I could not find a setting in the API documentation to control this.
- I was also hoping to fit more per page when exporting (from the API) but when I tried to use the zoomfactor parameter such as "zoomfactor":50 the API returns an error in the response:
{"status":"failure","summary":"EXTRA_KEY_FOUND_IN_JSON","data":{"errorCode":8542,"errorMessage":"Unknown JSON attribute(s) found in the parameter CONFIG."}}
Should this be working?
Thanks for any help!
Alex.