Error Importing to Google Sheet



  • Scott Henderson CTO
    Celigo University Level 1: Skilled
    Answer Pro
    Top Contributor

    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}}

  • Dave Guderian
    Celigo University Level 4: Legendary
    Awesome Follow-up

    Scott- Thanks for the help. I just tested and that did the trick! Thanks so much!


Please sign in to leave a comment.