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",
"101@acme",
"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?