Parsing a JSON Response from SOQL Query

Question

Hi All.

I am having trouble with extracting my data from my Salesforce Input tool using a Custom Query.

It was a success in validating the query, as well as , I clicked on "Attempt to Parse JSON Response".

I expected to see my data but got this instead.

How Can I fix this? Is it with my SOQL query?

angiechen9762 · Answer

Thank you so very much! It worked.

apathetichell · Answer

@angiechen9762 recordID is an Alteryx tool. you'd add that and then use jsonParse in alteryx.

angiechen9762 · Answer

Hi, would you be willing to illustrate more on how to add recordId by modifying SOQL? I search around but only found solutions using other coding languages after getting the results.

example SOQL:
SELECT Id, AccountId, AccountName, CreatedDate  form  Opportunity WHERE CreatedDate >= 2024-04-01T00:00:00Z