Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Parsing a JSON Response from SOQL Query

bryanmac_92
7 - Meteor

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.

Capture.PNG

 

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

 

Query.PNG

1 REPLY 1
danilang
19 - Altair
19 - Altair

Hi @bryanmac_92 

 

Start by adding a record ID and then using a JSON Parse tool to break down your data into name value fields.  From there, you need to narrow down to the actual values that you're looking for.  See here for a good example.

 

Dan

Labels