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

Status: Open · Asked by videoeditor on · 0 views

videoeditor — Question ·
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]"

Attachments

Pabbly Connect Google Sheet Response.JPG
Pabbly Connect JSON Payload Error.JPG
Pabbly Connect JSON Payload.JPG
Arshil Ahmad — Reply ·

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.

Back to all forum threads · Log in to reply