Skip to main content
Question

Salesforce Generic SOQL query

  • January 12, 2024
  • 0 replies
  • 103 views

Hi All,

I have created a pipeline to fetch some data from Salesforce to quickbase i used Salesforce Generic SOQL query step but the output i received from this step unable to use in the next steps due to the popup is showing no attributes. How to write a jinga script to use the output of SOQL query.



------------------------------
Hema Venkata Sainath Vemula
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+9
  • Registered
  • January 12, 2024

When you run the pipeline - what is the format of the payload you get back from the query? If you look at the logs - you should see the raw output of your query. You would base your next steps on that. If the payload response is JSON for example - then you can just do bracket or dot notation to access the data. 

So in future steps you can just do like {{a.data.key}}, {{a.key}}, {{a["data"]["key"]}} - whatever the JSON structure is like and target the key value pairs that you need. 



------------------------------
Chayce Duncan
------------------------------