JSON issues using MSGRAPH for Excel

[Bill51106]

Hello everyone!

I have been using the following guide for reference LINK 

How do I get my Excel file into JSON correctly? I used the following script:

function main(workbook: ExcelScript.Workbook): TableData[] {
    // Get the first table in the "PlainTable" worksheet.
    // If you know the table name, use `workbook.getTable('TableName')` instead.
    const table = workbook.getTable('Table1');

    // Get all the values from the table as text.
    const texts = table.getRange().getTexts();

    // Create an array of JSON objects that match the row structure.
    let returnObjects: TableData[] = [];
    if (table.getRowCount() > 0) {
        returnObjects = returnObjectFromValues(texts);
    }

    // Log the information and return it for a Power Automate flow.
    console.log(JSON.stringify(returnObjects));
    return returnObjects

  // This function converts a 2D array of values into a generic JSON object.
  // In this case, we have defined the TableData object, but any similar interface would work.
  function returnObjectFromValues(values: string[][]): TableData[] {
    let objectArray: TableData[] = [];
    let objectKeys: string[] = [];
    for (let i = 0; i < values.length; i++) {
      if (i === 0) {
        objectKeys = values[i]
        continue;
      }

      let object: { [key: string]: string } = {}
      for (let j = 0; j < values[i].length; j++) {
        object[objectKeys[j]] = values[i][j]
      }

      objectArray.push(object as unknown as TableData);
    }

    return objectArray;
  }

  interface TableData {
   
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
    "X": string
  }
}

But the Flow fails with a 413 error.

[grantjenkins]

What's the trigger for your flow? And what's the original Excel data/payload you are working with before running the Office Script?

If you're following the instructions from the site you linked to, then not sure why you're using Office Scripts at all. Are you wanting to use the Graph API to add your rows as per the instructions on the site?

[Bill51106]

@grantjenkins I don't know how to get my data into JSON without office scripts?

[grantjenkins]

Where is your data coming from initially? Just wondering what your initial data looks like prior to trying to get it into JSON format.

[grantjenkins]

Are you initially wanting to get your data from an Excel Table? If so, then you should be using List rows present in a table that will retrieve all the records and will already be in JSON format.

[grantjenkins]

See your other post for details.

Re: JSON array object error - Power Platform Community (microsoft.com)