Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help Needed: "An array can't be at the top level" Error in Build JSON Tool

DFstr
7 - Meteor

Hi everyone,

I'm encountering an issue with a Build JSON tool that I hope you can help me with. I'm trying to clean and transform a JSON file, and then output it again as a JSON file. However, after using a JSON parsing tool, I'm getting an error message stating "An array can't be at the top level".

Here's a brief overview of what I'm doing:

  1. Input: I start with a JSON file (I'm attaching a sample for reference).
  2. Process: I use a JSON parsing tool to process this file.
  3. Error: After parsing, when I attempt to rebuild the JSON, I encounter the error.

I'm not sure how to resolve this issue. The error seems to suggest that the tool does not accept a JSON array at the top level of the file. However, I'm unclear on how to modify the file or adjust the tool's settings to bypass this problem.

I would greatly appreciate any insights or suggestions on how to handle this. I'm also attaching my workflow and a sample input file for your reference.

Thank you in advance for your help!

2 REPLIES 2
TimN
13 - Pulsar

I tried removing "0." from the JSON Field Name and it seems to work.

DFstr
7 - Meteor

indeed - thanks!

Labels