Google Sheet to PDF Monkey - Dynamic Data (JSON Payload)

[videoeditor]

Your Workflow URL

IjU3NjUwNTZmMDYzMDA0Mzc1MjZkNTUzYzUxMzUi_pc

Hello, I have a problem to set the Dynamic Data (JSON Payload) in the Action of PDF Monkey when a row is modified in Google Sheet.
In the response from Google Sheet I receive a variable called "Itinerary" and it's value it's a JsonString.

Response:
"
Variable: Itinerary
Value: {"day":1,"date":"08/08/23","parkAct":"Arrival","parkActUrl":"URL","parkActDesc":"","accommodation":"Marera Valley","accommodationUrl1":"URL","accommodationUrl2":"URL","accommodationUrl3":"URL"},{"day":2,"date":"09/08/23","parkAct":"Ngorongoro Crater","parkActUrl":"URL","parkActDesc":"","accommodation":"Marera Valley","accommodationUrl1":"URL","accommodationUrl2":"URL","accommodationUrl3":URL"}
"

I need to receive in PDF Monkey the string, but I get the following error in the Response of the Action "PDF Monkey":

Dynamic Data (JSON Payload):
"
{ "name": "1. Name : Marta Gordillo", "pax": "1. Pax : 3", "adults": "1. Adults : 2", "children": "1. Children : 1", "safari_cars": "1. Safari Cars : 2", "safari_per_adult": "1. Safari Per Adult : 1930.40", "safari_per_child": "1. Safari Per Adult : 1930.40", "zanzibar_per_adult": "1. Zanzibar Per Adult : 786.00", "zanzibar_per_child": "1. Zanzibar Per Child : 408.00", "extras_per_adult": "1. Extras Per Adult : 1056.00", "extras_per_child": "1. Extras Per Child : 756.00", "total_days": "1. Total Days : 9", "safari_days": "1. Safari Days : 5", "zanzibar_days": "1. Zanzibar Days : 4", "total_price": "1. Total Price : 21210","oscar_africa":"1. Oscar Africa : 1","explore_africa":"1. Explore Africa : 0","itinerary":["{"day":1,"date":"08/08/23","parkAct":"Arrival","parkActUrl":"URL","parkActDesc":"","accommodation":"Marera Valley","accommodationUrl1":"URL","accommodationUrl2":"URL","accommodationUrl3":"URL"},{"day":2,"date":"09/08/23","parkAct":"Ngorongoro Crater","parkActUrl":"URL","parkActDesc":"","accommodation":"Marera Valley","accommodationUrl1":"URL","accommodationUrl2":"URL","accommodationUrl3":URL"}"] }
"


Error Label: "Errors Payload 0"
Error Value: "unexpected character (after itinerary[1]) at line 1, column 420 [parse.c:764]"

 

[ArshilAhmad]

Hi @videoeditor,

It seems like the issue has been fixed now and you are getting the correct response.

In the 'Find Document' action event, please map the Document ID from the second step of your workflow.