google-sheets-apimake.com

Google Sheet API batchGet unable to parse range with Integromat

I am trying to use the batchGet method of Google Sheets found here. The ranges and sheetID work fine when I am using the "Try this API" feature. The problem is Integromat requires me to form the URL manually, it's not clear how that's done.

I am trying: https://sheets.googleapis.com/v4/spreadsheets/{my sheet ID}/values:batchGet?ranges=[sheet1!a1:a2,sheet1!b1:b2]

I keep getting the error:

"400: INVALID_ARGUMENT - Unable to parse range: "

Integromat is supposed to automatically replace special characters with their % form so I don't think it's that.

Solution

  • Try this instead,

    /v4/spreadsheets/1MiLOwcEImnih0svZBrGwMQZ3xi3vSchhNWPiPA8Tcz0/values:batchGet?ranges=Availability!a1%3Aa2&ranges=Availability!b1%3Ab2

    Instead of using,ranges=[sheet1!a1:a2,sheet1!b1:b2] it should be,

    ranges=sheet1!a1:a2 & ranges=sheet1!b1:b2

    Of course with URL encoding, which should be handled by Integromat.