Skip to Main Content
Nintex Ideas

đź‘‹ Use this site to provide feedback and ideas for all Nintex Products. See our post on Nintex Community "Welcome to Nintex Ideas" for more details on Nintex Ideas, how an idea is handled by our product teams and more!


If you have questions about Nintex Ideas, please contact ideas@nintex.com

If you require support, please visit Nintex Customer Central

If you have a sales inquiry, please contact sales@nintex.com

Status Completed
Categories Xtensions
Created by Marc Bueno
Created on Jan 7, 2020

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