• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

JSON trigger from Glideapp not recognised

Status
Not open for further replies.

Rajeev

Member
My Glide app sends a JSON payload via webhook to Pabbly.

However, upon receipt of the payload, Pabbly splits the JSON into its fields - it does this whether Simple Response is toggled on or off.
This means that I cannot use the iterator.

Do you have a solution for this? I've pasted the JSON below for your review.

--
To try to find a workaround, I had the JSON encoded in Base64 by Glide and then sent to Pabbly.
I then used the Data Transformer to decode the JSON.

The decoder adds a string to the start of the
--
JSON [2023-10-04T18:22:22.012Z] [INFO]
--

so I added a Formatter step to find and remove this regular expression. The final result is the JSON exactly as sent by Glide.

However, when I try to use the iterator on this input, the result is empty.

JSON:
    {
  "cart": [
    {
      "item_id": "hm5CJkl4TVO8xdwEr8KWXA",
      "item_name": "First Listing Test Title",
      "item_price": 25000,
      "seller_email": "[email protected]"
    },
    {
      "item_id": "lXSLOul6R0SFeYiVzGsKPg",
      "item_name": "shirt",
      "item_price": 15000,
      "seller_email": "[email protected]"
    },
    {
      "item_id": "fkFkQuxlTXaClt2AUGk4Vg",
      "item_name": "Camisa Rosa Farm PP",
      "item_price": 17500,
      "seller_email": "[email protected]"
    },
    {
      "item_id": "vRoRrwIYR3Otl1DQxy5y8w",
      "item_name": "Blusa len o estampada flor de sol",
      "item_price": 20000,
      "seller_email": "[email protected]"
    },
    {
      "item_id": "gFzLU-51TVilAdlckzh89Q",
      "item_name": "First Listing Test Title",
      "item_price": 25000,
      "seller_email": "[email protected]"
    }
  ]
}

1696520113998.png


As you can see, the iterator recognises 4. Result [] as an array but its response is empty.
 

Supreme

Well-known member
Staff member
Hey @Rajeev

As the JSON you are attempting to supply was initially encapsulated within an object, the Iterator action step is encountering issues in obtaining a suitable JSON array. Consequently, we have modified your workflow by implementing the Select Transform action step.

Please check your workflow once -

1696589660225.png
 
Status
Not open for further replies.
Top