Open Dynamic JSON Handing in Pabbly Chat Workflow

[Kishore]

Grant Account Access for Support

1. I authorize the Pabbly Support Team to access my account for troubleshooting purposes.

WhatsApp Number

+1 5198076062

Email Address

[email protected]

Hi,

I’m trying to use Pabbly Chat Workflow to call a third-party calendar service.

I have a dynamic slots JSON that I’m attempting to convert response time into a list of options and send as a message to the user.

Is there a way to achieve this? I can see that static values can be mapped to Pabbly user custom variables and reused in the workflow, but handling dynamic JSON is a bit challenging.

Example API and response:
https://api.cal.com/v2/slots?eventTypeId=5598587&start=2026-05-05&end=2026-05-07&timeZone=America/Toronto

{ 
"data":
{   
"2026-05-06": [ {"start": "2026-05-06T09:00:00.000-04:00"}, {"start": "2026-05-06T09:30:00.000-04:00"}],
"2026-05-07": [{"start": "2026-05-07T09:00:00.000-04:00"},{"start": "2026-05-07T09:30:00.000-04:00"}]
},
"status": "success"
}

Workflow Link for reference : https://chatflow.pabbly.com/app/flows/edit/69fa1abf1f443c75e7a40ec5

 

[Preeti Paryani]

Hi @Kishore,

Thanks for reaching out to us.

If you want to pass dynamic values within the API request, you can use Contact Custom Variables for the same within Pabbly Chatflow.

You can refer to the attached tutorial from the shared timestamp to better understand how to configure and use dynamic variables in your workflow.

 

[Kishore]

Hi @Kishore,

Thanks for reaching out to us.

If you want to pass dynamic values within the API request, you can use Contact Custom Variables for the same within Pabbly Chatflow.

You can refer to the attached tutorial from the shared timestamp to better understand how to configure and use dynamic variables in your workflow.

Hi Preeti,

Thanks for the recommendation. I’ve gone through several support videos, and most of them explain scenarios where a fixed key is mapped to a custom variable (i.e., a known key-value structure).
However, in my case the challenge is that the keys themselves are dynamic (dates), so I first need to transform/process the JSON before I can map the values into custom variables.

Example from my data:​

From the response, I need to derive values like:

• Date1: 2026-05-06
  • Time_1_1: 09:00 (from "start": "2026-05-06T09:00:00.000-04:00")
  • Time_1_2: 09:30 (from "start": "2026-05-06T09:30:00.000-04:00")
• Date2: 2026-05-07
  • Time_2_1: 09:00
  • Time_2_2: 09:30

Sample JSON:​

{
  "data": {
    "2026-05-06": [
      { "start": "2026-05-06T09:00:00.000-04:00" },
      { "start": "2026-05-06T09:30:00.000-04:00" }
    ],
    "2026-05-07": [
      { "start": "2026-05-07T09:00:00.000-04:00" },
      { "start": "2026-05-07T09:30:00.000-04:00" }
    ]
  },
  "status": "success"
}

My question:​

Is there any JavaScript-based processing node (or transformation step) in Pabbly Chatflow where I can iterate over this object, extract dynamic keys (dates), and restructure the data before mapping it into custom variables?
For example, something like a JS code step / transform node where I can loop through:

• Object.keys(data)
• then extract date + start time
• and format them into a usable structure for variables

Context:​

I am building an appointment booking workflow connected to an API-based calendar system, so handling dynamic date/time slots is critical in this flow.
Could you please guide me on the best approach for this scenario?


Thanks in advance.

 

[ArshilAhmad]

No, that’s not possible directly in Pabbly Chatflow.

Instead, you can send the data to Pabbly Connect, execute your endpoint using the API (Pabbly) module to fetch the slots, then use Code (Pabbly) to manipulate the data as needed, and finally send the message to the user.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com