Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] #10081

Closed
ivanmizzi opened this issue Jan 26, 2024 · 4 comments
Closed

[BUG] #10081

ivanmizzi opened this issue Jan 26, 2024 · 4 comments
Labels
bug Something isn't working

Comments

@ivanmizzi
Copy link

Describe the bug
Getting an error "unexpected token in JSON at position 0" when adding a row when using the "add_a_worksheet_tablerow" in Excel online.

To Reproduce
Steps to reproduce the behavior:

  1. add the "add_a_worksheet_tablerow" for Excel online to the worklow
  2. Fill in valid values for "Microsoft Excel Account", "Folder Id", "Item Id", "Table Id"
  3. for "values" pass a 2-dimentional error
  4. Click test
  5. See error

Expected behavior
Adding a row when using the "add_a_worksheet_tablerow" in Excel online without an error

Screenshots
image

image
image
image
image
image

Desktop (please complete the following information):
Chrome on Windows

Smartphone (please complete the following information):
N/A

Additional context
Add any other context about the problem here.

@ivanmizzi ivanmizzi added the bug Something isn't working label Jan 26, 2024
@vunguyenhung
Copy link
Collaborator

The Values prop expect 2 dimensions array. So you need to pass in the value like [["A", 1, 2], ["B", 3, 4]]

@ivanmizzi
Copy link
Author

As per screenshots, this was passed as a 2 dimensional array, in a variety of tests, and it still returned an error.

@ivanmizzi
Copy link
Author

Testing again using copy and paste of the example supplied:

image

@vunguyenhung
Copy link
Collaborator

vunguyenhung commented Jan 30, 2024

Hey @ivanmizzi, would you mind following this example?

The Values prop actually accepting the JSON string (not JSON value).
image

For a workaround, you can try to pass in the Values prop {{ JSON.stringify(steps.node.$return_value) }}
image

I've create another ticket to support JSON array here #10134

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants