Error Importing to Google Sheet
Im trying to import data into a google sheet using the marketplace connector and believe I am close. I am receiving an error and not sure if its something with my mapping or something else in my setup. I am exporting from HubSpot, but I dont believe that makes a difference in this scenario. As always any help is appreciated.
0
Comments
The error you are seeing is due to an embarrassing bug in our UI. The root problem is when you save the import flow step from the 'Simple' toggle at the top, then it wipes out the pre-configured 'HTTP request body' field. The work around is to paste the following value back into the 'HTTP request body' field, and then always save from the 'HTTP' toggle view on the top. We are hoping to patch this UI bug asap, and we are really sorry about this!
{"values": [
[{{#each record}}{{#if @first}}{{{jsonSerialize this}}}{{else}},{{{jsonSerialize this}}}{{/if}}{{/each}}
]
]
}
Scott- Thanks for the help. I just tested and that did the trick! Thanks so much!
Please sign in to leave a comment.