• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

videoeditor

Member
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 Google Sheet Response.JPG
    64.7 KB · Views: 134
  • Pabbly Connect JSON Payload Error.JPG
    Pabbly Connect JSON Payload Error.JPG
    62.4 KB · Views: 113
  • Pabbly Connect JSON Payload.JPG
    Pabbly Connect JSON Payload.JPG
    110.9 KB · Views: 97

ArshilAhmad

Moderator
Staff member
Hi @videoeditor,

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

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