• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Log in
  • ☰
  • Solutions
  • Forums
  • Tickets
New Topic
Discussions Q & A Recipe Building
S

Saul Macht

started a topic 11 months ago

Salesforce Report

I am using the Salesforce Get Report action, but I don't understand how to retrieve the values of each record in my report to map into the next steps in my recipe. The output just gives me this:

image

Patricia Andrea Guevarra

said 11 months ago

Hi Saul,


Thanks for reaching out! You can refer to this sample recipe: https://www.workato.com/recipes/665473-parse-report?st=e36fbc#recipe


To explain:


First, you have to do a repeat action on the Rows, so that you can get the results for every row in the report.


Next, in the fields where you want to input the row values, you must use the following formula:

Columns.where(name: 'column_name').pluck("value").first

Where

Columns is the Columns data pill nested under Rows

column_name is the column name. This must match the column name that shows in the API or the job output.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Expert Hour
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
Workato 2018 © | Privacy | Terms | +1 (844) GO-WORKATO
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato