• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Web Services Node w XML file that has many records to process

 5 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Barb Regnier
Basic Member Send Private Message
Posts: 4
Basic Member
11/27/2012 2:02 PM
First I will state I have not ever worked with XML files or the Web Service Node.  

We need to build a process flow to take in the St. Croix Systems Purchase Requests XML file which will have many "records" in it by using the Web Service.   We will then build a file that will be used to create requistions in RQ500.   How can I loop through the XML file/Web Service to get all the "records"?  

We also have to turn around and send them back the PO information and this would also be a multi record XML file.

Any help would be greatly appreciated.

Barb
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
11/27/2012 2:33 PM
To read in the XML file you have to also build an .xsd file which basically is the mapping of the data and is referenced in the XML node in ProcessFlow. I used a FileAccess node to bring in the file and then the XML node to parse it.

When I had to write the data back, I simply used the MsgBuilder to create/format my file and a FileAccess to write it back out. I tried to use the XML node to create my output data but someone recommended this easier solution to me.

You should be able to find information on XSD files on line but if you need additional help, feel free to email me.
David Williams
Barb Regnier
Basic Member Send Private Message
Posts: 4
Basic Member
11/27/2012 3:59 PM
Thanks David,

To get the file however I need to use the Web Service node.  How can I loop through it?
All the other Web Service examples I've seen are pretty much single "reads".
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
11/27/2012 7:09 PM
I'm not familiar with using the Web Service node, but in the XML node you specify the Input source for your data and then reference the local XSD file to use to parse the data. I'm guessing the data returned in your Web Service (webService_outputData ?) is the Input source.
David Williams
Barb Regnier
Basic Member Send Private Message
Posts: 4
Basic Member
12/5/2012 3:55 PM
David,

I still working on this.   I have loaded the xsd file into the XML node.   I don't however see how you would keep looping through the input file and using the XML parser to get the next requisition and the next and the next.

Barb
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
12/5/2012 5:25 PM
If you just have one record then you can use an Assign to assign a value to your variables: poNumber=XML5700_output.PO.PONUM
If you have multiple records, you can get the number of records to process using: lineCount=XML5700_output.*:OLINE.length()
You would then use a Branch to loop through your records as long as LineCounter
My XML file had a header section "PO" and several lines in the line section "POLINE" and my file only had one PO record per file.
David Williams