topic Re: Form Submission with Power Automate creates only errors in APIs & Integrations

Form Submission with Power Automate creates only errors

Harling — Wed, 06 Nov 2024 10:04:23 GMT

Hi,

I try to submit data to a HubSpot form through Power Automate. I use a HTTP Post function, using this URI https://api.hsforms.com/submissions/v3/integration/submit/:portalId/:formGuid (with my portal and form ID).
It has been working last week, now I suddenly get the following error:
Invalid input JSON on line 1, column 1: Cannot construct instance of `com.hubspot.formsubmission.core.models.PublicApiFormSubmissionRequest$Json` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value ('fields').

The JSON body looks like this
"fields": [
{
"objectTypeId": "0-1",
"name": "email",
"value": "@{triggerBody()?['entity']?['email']}"
},
{
"objectTypeId": "0-1",
"name": "salutation",
"value": "@{triggerBody()?['entity']?['salutation']}"
},.....

What can this be causing the error message?

Thank you for any hint.

Re: Form Submission with Power Automate creates only errors

Jaycee_Lewis — Wed, 06 Nov 2024 22:59:24 GMT

Hi, @Harling 👋 Thanks for including those details in your post. Interpreting Power Automate errors can be a bit tricky. Not impossible, but challenging. I'd like to invite a mix of community members to the conversation who have posted or answered Power Automate questions — hey @coldrickjack @AKhan786 @NThoman @SWesthagen have you run into this situation?

Thank you for taking a look! — Jaycee

Re: Form Submission with Power Automate creates only errors

BStokes — Fri, 08 Nov 2024 15:03:49 GMT

I’m also encountering this issue when trying to submit data to a HubSpot form via Power Automate. The error message about invalid JSON format on line 1 has been a blocker for me too, even though it was working previously.