What is the best way to get this json response into a format for my next zap?
Right now i am getting back a jsob blob that looks something like
I want to take this info coming from my webhook response and map the fields into an Action for a CRM, but i can’t figure out a way to easily transform that info format wise.
Best answer by Troy Tessalone
View original
+14
It’s possible with Code, but it means the JSON would have to be handled/prepped in the Code step before trying to pass it to the JSON.parse() method.
If you need help, consider hiring a Certified Zapier Expert: https://zapier.com/experts/automation-ace
Essentially the entire “raw body” , we want to use to send to a crm for example: {"ContactId":1701,"LoanId:2551","LoanUrl":"https://my.dev.xx.tech/loan?xxx",LoanId":"xx","RefId":"xx","FirstName":"John","LastName":"Homeowner","Email":"john.xx.3.10.2023.1007a@test.xx.com",”
I would want to come out like:
+14
What data from the JSON do you need parsed out to use in other Zap steps?
Okay, if i cant change that do you have any other suggestions to recommendations for how to get to the end result being “formatting this data so that i can send it to another app”?
+14
This help article explains the error: https://itsjavascript.com/unexpected-token-u-in-json-at-position-0
It means the JSON would have to be handled/prepped in the Code step before trying to pass it to the JSON.parse() method.
It may be related to this parameter for which the value doesn’t have the double quotes.
+14
Please clarify what Formatter action is being used in Step 2
+14
Ok, go head and remove the .trim().
Please post the other encountered error message after testing.
+14
That error makes it should like the mapped variable had “No data”.
Please post screenshots of your encountered error message.
Now getting this :
TypeError: Cannot read property 'trim' of undefined
+14
Hi
Try adding .trim() after the inputData.RAW to get inputData.RAW.trim()
+14
We’d need to see detailed screenshots with how your Zap steps are configured, thanks.
thanks
SyntaxError: Unexpected token u in JSON at position 0” as an error
I should also note that in the input data, i am using the “Raw Body” from my webhook zap.
+14
Hi
Good question.
Try using a Code step to parse the JSON.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
