Load XML information by http protocol - Qlik Community

Report Inappropriate Content · ‎2011-09-01

Hi people,I 'm new in this forum and I have few experience with the qlikview tool.

I have question about load information:

I need to connect a my ERP System by http protocol. I have done to connect succesfully and the system retunned this xml (view below). Then, I need captured the fields and values that this are inside of the "tag".

I have tried System's ETL but I don't find a solution, can you help me ??

Thanks a lot for advance and I'm sorry for my english... 🙂

from Barcelona,

Miquel.

rwunderlich · ‎2011-09-01

You can process the returned XML with load from FIELD.

-Rob

Report Inappropriate Content · ‎2011-09-05

Hi Rob,

Thanks a lot, but my problem is this from returned XML:

...

<content name="P_LIFNR" ...>XXXvalueXXX</content>

...

With load from FIELD, this operation capture this data: field = name , value ='P_LIFNR

By example:

and I need this situation --> field = P_LIFNR and value XXXvalueXXX

How I can do with the load?

MIquel.

rwunderlich · ‎2011-09-07

Take a look at using the TextBetween() function and possible the subfield() function to parse the data out the way you want.

-Rob