Help with Array Elements

I’m using Microsoft’s Graph API to access Excel Worksheet data. The problem is that this data is returned as an array of unnamed elements like this:

    [
      101,
      "acme",
      "Chad",
      "Acme",
      "[email protected]",
      "Acmecorp1",
      "[email protected]",
      63109,
      "",
      "",
      "yes",
      "25",
      "US/Central",
      "888",
      "888555123",
      "Acme Corp",
      "8885551234",
      "acme",
      "US and Canada",
      "yes",
      "yes",
      "yes",
      "google",
      "attnew",
      "Simple User"
    ]

I need to add the array elements to a mysql table. Is it possible to name these existing elements for easier parsing, or should I just get the index of each element to add it to the table?

Hey @jhambach, you should be able to use the Set node to define the name and value (using expressions pointing to each of your array values) of each field. Let me know if you run into any trouble with this :slight_smile:

1 Like

That’s what my plan was but wanted to make sure it was sound. Thank you!

1 Like