Skip to main content
Nintex Community Menu Bar
Question

REST API Sheets v4 - No Field Names


Forum|alt.badge.img+2

I have a working connection with Google Sheets but I am experiencing issues with rendering the field names (Col names), which prevents me from doing anything else but listing the sheet values.

I understand from other posts on the Community, e.g. https://community.skuid.com/t/calling-third-party-rest-api-with-skuid that it most probably have everything to do with “Path to Content”, but I have been testing with all possible combinations (at least it feels like that) and I am in need of some input that would enable me to proceed with getting a proper Google Sheet integration with Read, Insert, Update, Delete commands fully functional.

I have been referring to the Google API Explorer
https://developers.google.com/apis-explorer/#p/sheets/v4/

and been using both:
sheets.spreadsheets.values.get
sheets.spreadsheets.values.batchGet

e.g.
/v4/spreadsheets/1xWSUmE0x10Ci3pUu_KgDPU8DNU4bWb2Edy2gv2tLH6o/values:batchGet?majorDimension=DIMENSION_UNSPECIFIED&ranges=Sheet1&valueRenderOption=FORMATTED_VALUE&fields=valueRanges%2Fvalues

What am I missing?

Cheers

Erik

Translate
Did this topic help you find an answer to your question?

4 replies

Forum|alt.badge.img+13

Erik, I personally haven’t tried using v4, but I did get this to work using v3, and I recall being able to find the Column / Field Names within the returned payload, you may have to have a separate Model that just gets the sheet “Metadata” while another Model gets the sheet “Data”, since if you use Path to Contents to limit the Model data down to the Array of data records, you will lose the “metadata” which is available in a different Path to Contents. Solution: Use two Models, each with the same URL, but with different Paths to Contents, one Model for Metadata, one Model for Data.

Here is a post where I walk through connecting to Google Sheets using v3 of the API:

https://community.skuid.com/t/can-i-use-data-services-to-connect-to-a-google-sheet

Translate

Forum|alt.badge.img+2
  • Author
  • Novice
  • 5 replies
  • July 10, 2024

Hi Zach, thanks for reaching out. Oyes, I have been reading your post multiple times and I got v3 to work. But with v4 it is a whole different ballgame, but your suggestion of using two models sounds  as it will work. Will refer back once I have tried this out.

Translate

Forum|alt.badge.img+3

Hi Erik, did you get this working? I tried following https://community.skuid.com/t/can-i-use-data-services-to-connect-to-a-google-sheet but commented there I’m blocked just getting the model to access the sheet. What relative URL did you use in the data source URL? Thanks.

Translate

Forum|alt.badge.img+1

@Erik Hello, could you please share the instructions/documentation/steps which you followed to set up the connection between google sheets and Skuid. We are trying to do this in our org it would be really helpful for the community members to get these instructions from someone who already did this. Thank you.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings