Describe the issue/error/question
Good afternoon n8n community.
I have a question. I think I am overlooking something very obvious, but I can’t make it happen the way I want it.
I execute an http call, and I receive a response in the form of a json file, with only 1 record that contains an XML string.
The content of the XML string is posted below.
When I use the node XML to JSON and pass that string, the node only returns the first XML record. There is no error message, I’m just getting the first node.
When I just throw the XML in an online parser, it returns all the records fine.
In the XML to JSON node, in the ‘Property Name’ field I enter ‘Content’. The separate fields in the XML file are marked by the tags.
I would expect each ‘query’ record to be split out, but that does not happen.
What am I overlooking?
Many thanks for your help in advance,
Maarten
This is the JSON response:
`
Text Removed from original post an re-posted below
`
BramKn
June 28, 2022, 1:32pm
2
Hi @maartend
You XML doesn’t seem to contain separate items.
I don’t know how you are getting a proper XML from a parser? I am getting this If I try to format the XML that is found within content:
Could be that I am doing something wrong.
You also seem to have some numbers that are outside of any XML tag.
As far as I know that is not normal to have. I guess these are the numbers for the different rows you want to get.
1 Like
Hi Bram,
thanks for your response! Somehow, the data that I am posting seems to get messed up, and in the ticket there is missing some info. Let me see if I can fix that.
It seems that I need to copy it into the ticket a bit differently, here is the correct text. I’ll strip it out of my original message.
{"Content":"<query><d1_fld>100</d1_fld><d2_fld>800200</d2_fld><d3_fld>3</d3_fld><d4_fld>2022-03-31</d4_fld><dj_code>930</dj_code><page_nr>9</page_nr><period>3</period><trn_date>2022-03-31</trn_date><acct_nr>800200</acct_nr><sub_nr /><inv_nr>3</inv_nr><trn_desc>Omzet Hotel</trn_desc><vat_code>02</vat_code><cost_code>100</cost_code><pc_code /><amount>-128708.7400</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000061453</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000022319</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-11583.7900</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60T0TDIHH</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-743222.84</cr_amt><acct_bal>-743222.8400</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800000</d2_fld><d3_fld>2</d3_fld><d4_fld>2022-02-28</d4_fld><dj_code>930</dj_code><page_nr>6</page_nr><period>2</period><trn_date>2022-02-28</trn_date><acct_nr>800000</acct_nr><sub_nr /><inv_nr>2</inv_nr><trn_desc>Omzet keuken</trn_desc><vat_code>02</vat_code><cost_code>200</cost_code><pc_code /><amount>-17782.3900</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000038114</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000014960</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-1600.4200</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0O2VQZ</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-102807.77</cr_amt><acct_bal>-102807.7700</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800001</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800001</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet frisdranken</trn_desc><vat_code>02</vat_code><cost_code>200</cost_code><pc_code /><amount>-994.5000</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026400</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008203</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-89.5000</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0OCIII</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-14942.67</cr_amt><acct_bal>-14942.6700</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800002</d2_fld><d3_fld>5</d3_fld><d4_fld>2022-05-31</d4_fld><dj_code>930</dj_code><page_nr>15</page_nr><period>5</period><trn_date>2022-05-31</trn_date><acct_nr>800002</acct_nr><sub_nr /><inv_nr>5</inv_nr><trn_desc>Omzet warme dranken</trn_desc><vat_code>02</vat_code><cost_code>200</cost_code><pc_code /><amount>-6321.1700</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000082543</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000037629</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-568.9000</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60T0TEAX5</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-18829.42</cr_amt><acct_bal>-18829.4200</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800100</d2_fld><d3_fld>5</d3_fld><d4_fld>2022-05-31</d4_fld><dj_code>930</dj_code><page_nr>15</page_nr><period>5</period><trn_date>2022-05-31</trn_date><acct_nr>800100</acct_nr><sub_nr /><inv_nr>5</inv_nr><trn_desc>Omzet sterke drank</trn_desc><vat_code>01</vat_code><cost_code>200</cost_code><pc_code /><amount>-1835.1200</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000082525</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000037619</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-385.3800</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0O9HKM</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-7774.79</cr_amt><acct_bal>-7774.7900</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800101</d2_fld><d3_fld>5</d3_fld><d4_fld>2022-05-31</d4_fld><dj_code>930</dj_code><page_nr>15</page_nr><period>5</period><trn_date>2022-05-31</trn_date><acct_nr>800101</acct_nr><sub_nr /><inv_nr>5</inv_nr><trn_desc>Omzet wijn</trn_desc><vat_code>01</vat_code><cost_code>200</cost_code><pc_code /><amount>-9271.0400</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000082527</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000037620</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-1946.9200</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0O9M2M</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-26409.25</cr_amt><acct_bal>-26409.2500</acct_bal></query><query><d1_fld>200</d1_fld><d2_fld>800102</d2_fld><d3_fld>5</d3_fld><d4_fld>2022-05-31</d4_fld><dj_code>930</dj_code><page_nr>15</page_nr><period>5</period><trn_date>2022-05-31</trn_date><acct_nr>800102</acct_nr><sub_nr /><inv_nr>5</inv_nr><trn_desc>Omzet bier</trn_desc><vat_code>01</vat_code><cost_code>200</cost_code><pc_code /><amount>-2367.8800</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000082537</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000037626</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-497.2600</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0OEBM4</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-8722.63</cr_amt><acct_bal>-8722.6300</acct_bal></query><query><d1_fld>201</d1_fld><d2_fld>800005</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800005</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet ontbijt</trn_desc><vat_code>02</vat_code><cost_code>201</cost_code><pc_code /><amount>-5351.8300</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026388</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008195</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-481.6700</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0O9CYD</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-41933.26</cr_amt><acct_bal>-41933.2600</acct_bal></query><query><d1_fld>202</d1_fld><d2_fld>800000</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800000</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet keuken</trn_desc><vat_code>02</vat_code><cost_code>202</cost_code><pc_code /><amount>-3354.0800</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026416</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008951</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-301.8700</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0UV5EH</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-3354.08</cr_amt><acct_bal>-3354.0800</acct_bal></query><query><d1_fld>202</d1_fld><d2_fld>800002</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800002</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet warme dranken</trn_desc><vat_code>02</vat_code><cost_code>202</cost_code><pc_code /><amount>-836.8700</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026414</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008950</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-75.3200</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0UV1Z5</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-836.87</cr_amt><acct_bal>-836.8700</acct_bal></query><query><d1_fld>202</d1_fld><d2_fld>800203</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800203</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet Zaalhuur</trn_desc><vat_code>01</vat_code><cost_code>202</cost_code><pc_code /><amount>-5068.4700</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026412</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008209</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-1064.3800</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60T0TF9X0</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-43360.64</cr_amt><acct_bal>-43360.6400</acct_bal></query><query><d1_fld>203</d1_fld><d2_fld>800000</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800000</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet keuken</trn_desc><vat_code>02</vat_code><cost_code>203</cost_code><pc_code /><amount>-472.9400</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026420</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008953</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-42.5600</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0UZP8I</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-472.94</cr_amt><acct_bal>-472.9400</acct_bal></query><query><d1_fld>203</d1_fld><d2_fld>800001</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800001</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet frisdranken</trn_desc><vat_code>02</vat_code><cost_code>203</cost_code><pc_code /><amount>-334.4000</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026418</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008952</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-30.1000</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0UZO8E</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-334.40</cr_amt><acct_bal>-334.4000</acct_bal></query><query><d1_fld>203</d1_fld><d2_fld>800101</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800101</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet wijn</trn_desc><vat_code>01</vat_code><cost_code>203</cost_code><pc_code /><amount>-309.0100</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026422</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008954</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-64.8900</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0VESM2</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-309.01</cr_amt><acct_bal>-309.0100</acct_bal></query><query><d1_fld>203</d1_fld><d2_fld>800102</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800102</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet bier</trn_desc><vat_code>01</vat_code><cost_code>203</cost_code><pc_code /><amount>-152.0700</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026424</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008955</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-31.9300</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0VEUPQ</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-152.07</cr_amt><acct_bal>-152.0700</acct_bal></query><query><d1_fld>204</d1_fld><d2_fld>800000</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800000</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet keuken</trn_desc><vat_code>02</vat_code><cost_code>204</cost_code><pc_code /><amount>-44.7200</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026428</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008957</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-4.0300</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0VHA6W</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-44.72</cr_amt><acct_bal>-44.7200</acct_bal></query><query><d1_fld>204</d1_fld><d2_fld>800001</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800001</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet frisdranken</trn_desc><vat_code>02</vat_code><cost_code>204</cost_code><pc_code /><amount>-36.7000</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026426</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008956</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-3.3000</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0VH9P3</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-36.70</cr_amt><acct_bal>-36.7000</acct_bal></query><query><d1_fld>204</d1_fld><d2_fld>800101</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800101</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet wijn</trn_desc><vat_code>01</vat_code><cost_code>204</cost_code><pc_code /><amount>-855.8300</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026430</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008958</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-179.7300</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_69J0VHV8Q</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-855.83</cr_amt><acct_bal>-855.8300</acct_bal></query><query><d1_fld>302</d1_fld><d2_fld>800204</d2_fld><d3_fld>1</d3_fld><d4_fld>2022-01-31</d4_fld><dj_code>930</dj_code><page_nr>2</page_nr><period>1</period><trn_date>2022-01-31</trn_date><acct_nr>800204</acct_nr><sub_nr /><inv_nr>1</inv_nr><trn_desc>Omzet wellness</trn_desc><vat_code>01</vat_code><cost_code>302</cost_code><pc_code /><amount>-2789.2600</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000026410</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000008208</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-585.7400</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60T0TF959</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-7148.76</cr_amt><acct_bal>-7148.7600</acct_bal></query><query><d1_fld>304</d1_fld><d2_fld>800201</d2_fld><d3_fld>5</d3_fld><d4_fld>2022-05-31</d4_fld><dj_code>930</dj_code><page_nr>15</page_nr><period>5</period><trn_date>2022-05-31</trn_date><acct_nr>800201</acct_nr><sub_nr /><inv_nr>5</inv_nr><trn_desc>Omzet Hotel services</trn_desc><vat_code>01</vat_code><cost_code>304</cost_code><pc_code /><amount>-676.8600</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000082529</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000037621</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-142.1400</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0O9XWS</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-4688.55</cr_amt><acct_bal>-4688.5500</acct_bal></query><query><d1_fld>304</d1_fld><d2_fld>800202</d2_fld><d3_fld>3</d3_fld><d4_fld>2022-03-31</d4_fld><dj_code>930</dj_code><page_nr>9</page_nr><period>3</period><trn_date>2022-03-31</trn_date><acct_nr>800202</acct_nr><sub_nr /><inv_nr>3</inv_nr><trn_desc>Omzet verhuur</trn_desc><vat_code>01</vat_code><cost_code>304</cost_code><pc_code /><amount>-1296.6900</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000061451</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000022318</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>-272.3100</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0OEORK</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>0.0000</dr_amt><cr_amt>-6239.45</cr_amt><acct_bal>-6239.4500</acct_bal></query><query><d1_fld>401</d1_fld><d2_fld>800400</d2_fld><d3_fld>4</d3_fld><d4_fld>2022-04-30</d4_fld><dj_code>930</dj_code><page_nr>12</page_nr><period>4</period><trn_date>2022-04-30</trn_date><acct_nr>800400</acct_nr><sub_nr /><inv_nr>4</inv_nr><trn_desc>Omzet cancellation</trn_desc><vat_code>00</vat_code><cost_code>401</cost_code><pc_code /><amount>-3042.6200</amount><cur_code /><cur_amt>0.0000</cur_amt><dist_code /><rec_id>0000065154</rec_id><dist_qty>0.000</dist_qty><cn_id /><adm_code /><src_type>1</src_type><src_id>0000026342</src_id><exch_rate>0.000000</exch_rate><base_amt>0.0000</base_amt><grek_type /><vat_amt>0.0000</vat_amt><part_code /><trn_qty>0.000</trn_qty><trn_wgt>0.000</trn_wgt><proj_code /><xml_data /><link_id /><obli_nr /><wkr_trn>false</wkr_trn><l5_recid>_60D0OAEWB</l5_recid><l5_percdry>0.00</l5_percdry><l5_engval>0.00</l5_engval><l5_bkstuk /><l5_dmsref /><l5_wrkcost>false</l5_wrkcost><dr_amt>559.6600</dr_amt><cr_amt>-6524.11</cr_amt><acct_bal>-5964.4500</acct_bal></query>","ReturnParameters":null}
BramKn
June 28, 2022, 1:45pm
5
That makes more sense idd. Im gonna check.
Jon
June 28, 2022, 2:28pm
6
Hey @maartend ,
Give the below workflow a bash, The XML you have doesn’t group all the elements so a quick work around is to use a set node to just add around your xml and that then works.
3 Likes
Hi @Jon - great that does it wonderfully, thanks!
2 Likes
Bram thanks for your help today, great work!
3 Likes
I have the same issue on my workflow and its helps me a lot! Thanks
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.