In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors