# How to retrieve array data from api or HTTP Request?

**URL:** <https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513>\
**Category:** Questions\
**Tags:** quickchart\
**Created:** [July 31, 2025, 4:44am UTC](https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513 "2025-07-31T04:44:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mininxd](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mininxd/32/104446_2.png) [@mininxd](https://community.n8n.io/u/mininxd)\
**Post date:** [July 31, 2025, 4:44am UTC](https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513/1 "2025-07-31T04:44:04Z")

</div>

I have API result that resulted in array not JSON, and im tried with quick chart like this

 ![Screenshot_20250731-114508_Chrome~2](https://europe1.discourse-cdn.com/n8n/original/3X/3/f/3fcbcff459f7a2a792a0c4f1da45a7e830e6052e.png)  
 ![Screenshot_20250731-114038_Chrome~2](https://europe1.discourse-cdn.com/n8n/original/3X/c/1/c134fd765c691e0103aafa2aaae180a6eae5f504.png)  
Quick Chart Output :  
Labels Array is not a valid array, use valid JSON format, or specify it by expressions

HTTP Request Output :  
No fields - item(s) exist, but they’re empty

 ![Screenshot_20250731-114250_Chrome~2](https://europe1.discourse-cdn.com/n8n/original/3X/b/f/bf96ad789bb127974314b0c8b684f3b80cd649b6.png)

---

<div class="post-metadata">

**Author:** ![jabbson](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jabbson/32/87328_2.png) [@jabbson](https://community.n8n.io/u/jabbson)\
**Post date:** [July 31, 2025, 5:04am UTC](https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513/2 "2025-07-31T05:04:04Z")

</div>

You could try to aggregate the values into an actual array of items. See if this example helps:

---

<div class="post-metadata">

**Author:** ![John\_Hosack](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/john_hosack/32/105624_2.png) [@John\_Hosack](https://community.n8n.io/u/John_Hosack)\
**Post date:** [July 31, 2025, 5:21am UTC](https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513/3 "2025-07-31T05:21:15Z")

</div>

Jabbson’s solution works if you use “all item data into a single list” option for aggregate. That gives you a JSON with all the values in the “data” field as an array.  
If you want to preserve each value as it’s own item, you would need to use a code node. This is my first time posting on the forum, hopefully my workflow is available to you below as an example.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [August 7, 2025, 5:21am UTC](https://community.n8n.io/t/how-to-retrieve-array-data-from-api-or-http-request/159513/4 "2025-08-07T05:21:17Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
