Add a new idea Subscribe
Status Completed
Categories Xtensions
Created by Guest
Created on Jan 7, 2020

RELATED IDEAS

Google Sheets API - Collection Inside a collection

I was working with Google Sheets API and found that I am not to get some actions to work such as append values.

After further investigation, it appears that I need the format to be a collection inside a collection.

[[A,B,C],[D,E,F]]

I tested different ways but ultimately could not get that format.
  • Attach files
  • Guest
    Reply
    |     Sep 7, 2022
    Hi,

    Thanks so much for your feedback! I'm the Product Manager working on object support for NWC. We are currently working on object output support in NWC, where we will support objects and collections, within collections, and expect it to be completed in the upcoming months. In the example you outlined above, are you talking about collection inputs or outputs?

    Cheers,

    Rob
  • Guest
    Reply
    |     Sep 7, 2022
    @Rob, this would be inputs. As we are working with the Google Sheets API for appending to the sheet which takes the double array/collection as its value.
  • Guest
    Reply
    |     Sep 7, 2022
    Hi Kevin,

    Cool! After we complete work for object inputs to enable looping of collections etc. which is slated for Q2, we will follow with object input support. FYI, we are also looking at creating a google sheets connector this year so would love I'd love to hear about your use cases if you are interested in a catch-up?

    Cheers,

    Rob
  • Guest
    Reply
    |     Sep 7, 2022
    Hi Kevin,

    I believe that with the introduction of object support in Xtensions and the new Google Sheet connector (https://help.nintex.com/en-US/nwc/Content/Designer/Connectors/GoogleSheetsConnector.htm) this should now solve your request.

    Cheers,
    JB