Processing incoming XML in webhook pipeline

Question

Hi I have an XML file that contains stock levels that I want to import into a QB table via a webhook
The XML looks something like this:
&lt;DSV_WHSInventory&gt;&nbsp; &lt;HEAD&gt;&nbsp; &nbsp; &lt;Message_Id&gt;20230824010117&lt;/Message_Id&gt;&nbsp; &nbsp; &lt;Date_Time&gt;20230824010117&lt;/Date_Time&gt;&nbsp; &nbsp; &lt;Message_Type&gt;INVRPT&lt;/Message_Type&gt;&nbsp; &nbsp; &lt;Message_Version&gt;0200&lt;/Message_Version&gt;&nbsp; &nbsp; &lt;Sender_Id&gt;DSV_WMS_RP02&lt;/Sender_Id&gt;&nbsp; &nbsp; &lt;Sender_Company&gt;DSV Solutions&lt;/Sender_Company&gt;&nbsp; &nbsp; &lt;Recipient_Id&gt;ZAGOSOLR&lt;/Recipient_Id&gt;&nbsp; &nbsp; &lt;Recipient_Company&gt;ZAGOSOLR&lt;/Recipient_Company&gt;&nbsp; &lt;/HEAD&gt;&nbsp; &lt;Inventory&gt;&nbsp; &nbsp; &lt;Dstamp&gt;20230824010117&lt;/Dstamp&gt;&nbsp; &nbsp; &lt;InventoryCount&gt;&nbsp; &nbsp; &nbsp; &lt;Client_Id&gt;ZAGOSOLR&lt;/Client_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Sku_Id&gt;006&lt;/Sku_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Site_Id&gt;ZAGOSOLR&lt;/Site_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Condition_Id&gt;OK1&lt;/Condition_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Total_Qty&gt;42&lt;/Total_Qty&gt;&nbsp; &nbsp; &nbsp; &lt;Total_Alloc&gt;3&lt;/Total_Alloc&gt;&nbsp; &nbsp; &nbsp; &lt;Tracking_Level&gt;EACH&lt;/Tracking_Level&gt;&nbsp; &nbsp; &nbsp; &lt;Condition_Id_Map&gt;OK1&lt;/Condition_Id_Map&gt;&nbsp; &nbsp; &lt;/InventoryCount&gt;&nbsp; &nbsp; &lt;InventoryCount&gt;&nbsp; &nbsp; &nbsp; &lt;Client_Id&gt;ZAGOSOLR&lt;/Client_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Sku_Id&gt;007&lt;/Sku_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Site_Id&gt;ZAGOSOLR&lt;/Site_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Condition_Id&gt;OK1&lt;/Condition_Id&gt;&nbsp; &nbsp; &nbsp; &lt;Total_Qty&gt;27&lt;/Total_Qty&gt;&nbsp; &nbsp; &nbsp; &lt;Total_Alloc&gt;3&lt;/Total_Alloc&gt;&nbsp; &nbsp; &nbsp; &lt;Tracking_Level&gt;EACH&lt;/Tracking_Level&gt;&nbsp; &nbsp; &nbsp; &lt;Condition_Id_Map&gt;OK1&lt;/Condition_Id_Map&gt;&nbsp; &nbsp; &lt;/InventoryCount&gt;
....

What is the best way to get this XML stock data into a QB table?&nbsp;
Thanks for the help&nbsp;

------------------------------James van der Walt------------------------------

chayceduncan · Answer

As of my understanding today I don't believe there is a short / simple solution to it. There isn't anything in Pipelines that will convert XML to JSON unless you're using the Quickbase API.&nbsp;
I can't find anything about Jinja being able to parse a strict XML response but I could be wrong on that front. You could possibly write the entire XML payload into a Quickbase text field and try to use formulas to split it out and manage it somehow, but based on your sample payload that will get tricky given the list of inventory counts. Your best bet is to evaluate a non-pipelines solution and do either a codepage or custom script where you can access XML parsing libraries to be able to transform and load it into QB.&nbsp;------------------------------Chayce Duncan------------------------------

jamesvan_der_wa · Answer

Thank you! We've opted for a middle layer to fetch the XML doc and convert it first then forward it to a QB webhook. Either CSV or JSON. However, it seems that CSV is the easiest for QB to digest.

------------------------------
James van der Walt
------------------------------

Forum Discussion

Processing incoming XML in webhook pipeline

2 Replies

Related Content

Pipeline Help

Fetch JSON from incoming request

Three Words of Advice on Pipelines

Error listing for Pipelines?

Pipeline Jinja For Duration in Seconds