# XML node 50 records max?

**URL:** https://discourse.nodered.org/t/xml-node-50-records-max/97051
**Category:** General
**Created:** [13 May 2025 08:49 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051 "2025-05-13T08:49:47Z")
**Posts on this page:** 19
**Page:** 1

<div class="post-metadata">

### Author: ![leftymuller](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/leftymuller/32/102326_2.png) [@leftymuller](https://discourse.nodered.org/u/leftymuller)
#### Post date: [13 May 2025 08:49 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/1 "2025-05-13T08:49:47Z")

</div>

Hello All,

Ive been pulling some big data from an API and noticed that im only getting max 50 records

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/1/a1b19259980f435fac591052338b0ea5da78cd7b.png)

is there a way around this or another xml node ?

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2025 08:56 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/2 "2025-05-13T08:56:48Z")

</div>

I dont know of any built in limitation. Can you show us the data before the XML node?

Failing that, you could always DIY it by adding any XML parsing lib from NPM into a function node.

How to: [Use any npm module in Node-RED • FlowFuse](https://flowfuse.com/blog/2023/06/import-modules/)

---

<div class="post-metadata">

### Author: ![leftymuller](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/leftymuller/32/102326_2.png) [@leftymuller](https://discourse.nodered.org/u/leftymuller)
#### Post date: [13 May 2025 09:09 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/3 "2025-05-13T09:09:55Z")

</div>

Hi Steve.. Thanks for replying

Bit hard to show you all the data as its confidential data.. however it is showing 897217 bytes of data coming from the http node and in the state for the xml its showing 1480 records however it only returns 50?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/c/6c5c6e97d2ab9a0ad23e4994d78df055b94a095c.png)

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2025 09:17 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/4 "2025-05-13T09:17:24Z")

</div>

I dont need to see the actual data. Just that there are as many row as you suggest.

Try capturing the data in a file (feed the result of the HTTP Request to a file node), then open that file and verify how many `job`s there are in the source. It may turn out there are only 50 because the API pages the data (meaning you need to either make subsequent requests with the `next` page ID or add a parameter to set the page size larger!)

Once you have made a capture to file, you can try it out in an online XML to JSON convertor ([like this one](https://jsonformatter.org/xml-formatter))

EDIT: Actually, its right there in your screen shot. The data is paged. You will need to read the API docs to request more.

---

<div class="post-metadata">

### Author: ![leftymuller](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/leftymuller/32/102326_2.png) [@leftymuller](https://discourse.nodered.org/u/leftymuller)
#### Post date: [13 May 2025 09:19 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/5 "2025-05-13T09:19:43Z")

</div>

Thank you .. wasnt sure if that was related.

I will go to the vendor and ask 🙂

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [13 May 2025 09:20 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/6 "2025-05-13T09:20:37Z")

</div>

or try the [node-red-contrib-fastxml](https://flows.nodered.org/node/node-red-contrib-fastxml) node

(I am the author so would be interested if that fails also)

---

<div class="post-metadata">

### Author: ![leftymuller](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/leftymuller/32/102326_2.png) [@leftymuller](https://discourse.nodered.org/u/leftymuller)
#### Post date: [13 May 2025 09:30 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/7 "2025-05-13T09:30:09Z")

</div>

Hi dceejay.. Thanks for helping

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/7/07da09a4d705c4a2f677a886f52f67a496a836b4.png)

same result... its pointing to the vendors API as the issue ?

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [13 May 2025 09:30 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/8 "2025-05-13T09:30:43Z")

</div>

Yes - maybe it is a "paging" api and only sends that many in a chunk

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2025 09:31 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/9 "2025-05-13T09:31:50Z")

</div>

I really wish the node-red core XML looked so clean.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [13 May 2025 09:53 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/10 "2025-05-13T09:53:42Z")

</div>

in what way ? - so clean as what ?

---

<div class="post-metadata">

### Author: ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [13 May 2025 10:00 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/11 "2025-05-13T10:00:01Z")

</div>

Check the actual text you are getting from the API and confirm that there is only the first page there. Output it to a file and you should easily be able to check by searching for, for example, current\_page.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [13 May 2025 10:00 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/12 "2025-05-13T10:00:16Z")

</div>

Maybe you can ask the API to send 1480, all, or (say) 99999 entries ? Probably a parameter to can add to the query to set it.

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2025 10:16 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/13 "2025-05-13T10:16:33Z")

</div>

> [@dceejay](#):
>
> in what way ?

the output is **much** more friendly in fastxml vs core

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/3/53a088aa0b633c14724500ebddfbc9b84670b793.png)

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [13 May 2025 10:20 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/14 "2025-05-13T10:20:47Z")

</div>

Ah yes - indeed - I did try to make it so it could replace core - but the fastxml lib can't quite be a 100% match so it would break some users so I had to release it separately :-(... As it really is just in the margins of attribute handling it was mostly OK - but... yeah 🤷 if we could swap I would 🙂

---

<div class="post-metadata">

### Author: ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [13 May 2025 10:27 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/15 "2025-05-13T10:27:01Z")

</div>

You can set the xml output options to not use arrays if it is a single object (for example), there is a long list with options available

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2025 11:19 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/16 "2025-05-13T11:19:00Z")

</div>

True:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/4/14c3e90c3bc9e6a0edf9fef3e4120ee0212bacd0.png)

---

<div class="post-metadata">

### Author: ![leftymuller](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/leftymuller/32/102326_2.png) [@leftymuller](https://discourse.nodered.org/u/leftymuller)
#### Post date: [14 May 2025 04:20 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/17 "2025-05-14T04:20:45Z")

</div>

Just an update.. YES it was the API that's limiting

@dceejay I have change to your XML node... can notice a difference.

---

<div class="post-metadata">

### Author: ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)
#### Post date: [14 May 2025 14:10 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/18 "2025-05-14T14:10:31Z")

</div>

The issue is that if you then do have any attributes that you can't easily go from XML -\> JSON and then back to XML without losing anything. OK - not maybe not a problem for most but is useful if you need to - and was the default behaviour chosen.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [12 August 2025 14:11 UTC](https://discourse.nodered.org/t/xml-node-50-records-max/97051/19 "2025-08-12T14:11:24Z")

</div>

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