bioviajero
Member
Hello Pabbly Connect Team and Community,
I'm trying to build a workflow that involves Jotform, an external API (Open Exchange Rates), and then updating a field in the original Jotform submission. I'm encountering a persistent "ResponseCode 400 - Submissions couldn't updated" error on the Jotform "Custom API Request (Beta)" step.
Here's my workflow setup:
Trigger: Webhook by Pabbly - Catch Webhook (Preferred)
Receives data from a Jotform submission. This step works correctly, and I can see all the Jotform data, including the SubmissionID.
Example SubmissionID received: 6241109224492777311
Action: API (Pabbly) - Execute API Request
Method: GET
API Endpoint URL: https://openexchangerates.org/api/latest.json?app_id=MY_OPENEXCHANGERATES_APP_ID&base=USD (MY_OPENEXCHANGERATES_APP_ID is replaced with my actual App ID).
This step works correctly and returns the exchange rates, including Rates VES (e.g., 94.873392).
Action: Number Formatter (Pabbly) - Perform Math Operation
Numbers: 100,{{2.Response Received Rates VES}}
Operation: Multiply
This step works correctly and gives a result (e.g., 9487.3392). Let's call this {{3.Result}}.
Action: Number Formatter (Pabbly) - Decimal Conversion
Number (Required): {{3.Result}} (from the math operation step)
Decimal Length (Required): 2
This step works correctly and gives a result formatted to two decimal places (e.g., 9487.34). Let's call this {{4.Result}}.
Action: Jotform - Custom API Request (Beta) (This is where the error occurs)
Connection: Connected successfully using my Jotform API Key (7820bc3fe831b1169a2397584c0c9b07) which has "Full Access" permissions in Jotform.
Request Method: POST
API Endpoint URL: https://api.jotform.com/submission/{{1.SubmissionID}} (mapping the SubmissionID from the initial webhook, e.g., https://api.jotform.com/submission/6241109224492777311)
Payload Type: Form Data (application/x-www-form-urlencoded)
Add Headers:
Header 1 Label: APIKEY
Header 1 Value: 7820bc3fe831b1169a2397584c0c9b07 (my Jotform API Key)
Header 2 Label: Content-Type
Header 2 Value: application/x-www-form-urlencoded
Set Parameters:
Label 1: submission[fields][numero]
(numero is the exact "Unique Name" of the number field in my Jotform form that I want to update).
Value 1: {{4.Result}} (mapping the output from the "Decimal Conversion" step, e.g., 9487.34)
Error Received in Step 5 (Jotform Custom API Request):
ResponseCode: 400
Message: Submissions couldn't updated
Info: https://api.jotform.com/docs#submission-id
Things I've tried/verified:
The Jotform API Key has "Full Access". I even generated a new one.
The "Unique Name" of the Jotform field is indeed numero.
I've tried sending a static value (e.g., 123.45) in "Value 1" of "Set Parameters", and I still get the same 400 error. This makes me think the issue is not with the calculated value itself.
I've tried using submission[q_numero] (if the field ID was q_numero) but the unique name is just numero.
I tried with just numero as the Label in "Set Parameters" (instead of submission[fields][numero]), but that also resulted in an error. The submission[fields][unique_name] format is what's usually documented for Jotform's API for updating submission fields via POST.
I am trying to update a "Number" field in my Jotform.
Could you please advise on the correct configuration for the Jotform "Custom API Request (Beta)" module to update a specific field in an existing submission? Is there a different "Payload Type" or a different way to structure the "Set Parameters" data that I should be using for Jotform's API endpoint POST /submission/{id}?
Any help would be greatly appreciated!
Thank you.
I'm trying to build a workflow that involves Jotform, an external API (Open Exchange Rates), and then updating a field in the original Jotform submission. I'm encountering a persistent "ResponseCode 400 - Submissions couldn't updated" error on the Jotform "Custom API Request (Beta)" step.
Here's my workflow setup:
Trigger: Webhook by Pabbly - Catch Webhook (Preferred)
Receives data from a Jotform submission. This step works correctly, and I can see all the Jotform data, including the SubmissionID.
Example SubmissionID received: 6241109224492777311
Action: API (Pabbly) - Execute API Request
Method: GET
API Endpoint URL: https://openexchangerates.org/api/latest.json?app_id=MY_OPENEXCHANGERATES_APP_ID&base=USD (MY_OPENEXCHANGERATES_APP_ID is replaced with my actual App ID).
This step works correctly and returns the exchange rates, including Rates VES (e.g., 94.873392).
Action: Number Formatter (Pabbly) - Perform Math Operation
Numbers: 100,{{2.Response Received Rates VES}}
Operation: Multiply
This step works correctly and gives a result (e.g., 9487.3392). Let's call this {{3.Result}}.
Action: Number Formatter (Pabbly) - Decimal Conversion
Number (Required): {{3.Result}} (from the math operation step)
Decimal Length (Required): 2
This step works correctly and gives a result formatted to two decimal places (e.g., 9487.34). Let's call this {{4.Result}}.
Action: Jotform - Custom API Request (Beta) (This is where the error occurs)
Connection: Connected successfully using my Jotform API Key (7820bc3fe831b1169a2397584c0c9b07) which has "Full Access" permissions in Jotform.
Request Method: POST
API Endpoint URL: https://api.jotform.com/submission/{{1.SubmissionID}} (mapping the SubmissionID from the initial webhook, e.g., https://api.jotform.com/submission/6241109224492777311)
Payload Type: Form Data (application/x-www-form-urlencoded)
Add Headers:
Header 1 Label: APIKEY
Header 1 Value: 7820bc3fe831b1169a2397584c0c9b07 (my Jotform API Key)
Header 2 Label: Content-Type
Header 2 Value: application/x-www-form-urlencoded
Set Parameters:
Label 1: submission[fields][numero]
(numero is the exact "Unique Name" of the number field in my Jotform form that I want to update).
Value 1: {{4.Result}} (mapping the output from the "Decimal Conversion" step, e.g., 9487.34)
Error Received in Step 5 (Jotform Custom API Request):
ResponseCode: 400
Message: Submissions couldn't updated
Info: https://api.jotform.com/docs#submission-id
Things I've tried/verified:
The Jotform API Key has "Full Access". I even generated a new one.
The "Unique Name" of the Jotform field is indeed numero.
I've tried sending a static value (e.g., 123.45) in "Value 1" of "Set Parameters", and I still get the same 400 error. This makes me think the issue is not with the calculated value itself.
I've tried using submission[q_numero] (if the field ID was q_numero) but the unique name is just numero.
I tried with just numero as the Label in "Set Parameters" (instead of submission[fields][numero]), but that also resulted in an error. The submission[fields][unique_name] format is what's usually documented for Jotform's API for updating submission fields via POST.
I am trying to update a "Number" field in my Jotform.
Could you please advise on the correct configuration for the Jotform "Custom API Request (Beta)" module to update a specific field in an existing submission? Is there a different "Payload Type" or a different way to structure the "Set Parameters" data that I should be using for Jotform's API endpoint POST /submission/{id}?
Any help would be greatly appreciated!
Thank you.
