Salesforce Integration - Execute Report returning empty

Build Activities
,
#1

Hi.
I am trying to return the rows of a given report from Salesforce.
But, when running the activity “Execute Report”, only the report schema is being returned, and not the report data. I dont know if this is a problem with some kind of permissions in Salesforce that controls directly the way reports are returned via API, or something like that. Besides that, is still wierd how only the schema is returned. No errors comeback from the activity call too.

The report has some filters, and sometimes these filter will made the report empty, but that not case here, since im double checking if the report has data or no.

Any ideias? Permission maybe?

1 Like
#2

Did you find an answer to this question? I’m running into the same issue, unsure why - the report has values.

1 Like
#3

cfvenedam

Check the salesforce integration user permissions to execute reports and to see report fields

#4

Thanks for the response. Integration user has the correct permissions, I was able to get results for a different report. It looks like ‘Execute Report’ fails if there’s a ‘group by’ in the report, no way to specify ‘export only detail lines’ the way you can from the UI

1 Like
#5

An Alternative is use SOQL to get the desired data. It works like a charm and still manage to prevent from someone to change the report metadada and consequently break your bots

1 Like
#6

I guess your report type is a custom report type and you have “Object A with or without Object B” and in that case your object A does not related to Object B record so therefore your filter would only filter out object A.
Try to Change Custom Object.