Page 1 of 1

http connector content string

Posted: Wed Feb 22, 2017 3:37 pm
by thomas7467
Hi all,
I'm trying to transform http connector request content (one field with "," separtd items) to n fields (, that I can use for next steps.
Any ideas how to do that?
thank you,
Thomas

Re: http connector content string

Posted: Fri Feb 24, 2017 7:24 pm
by svecp
If I understand it correctly, you're trying to parse HTTP response into n fields, right?
There are two viable approaches:

Use Reformat and CTL function split() on the content field or;

Connect FlatFileReader component to the HTTPConnector, set File URL = port:$0.content:discrete and appropriate metadata on the edge behind FlatFileReader in case you need to work with response as with records. Metadata record in your case needs to have "," set as Field delimiter and EOF as record delimiter set to true.
To illustrate this case:
httpresponse.PNG
httpresponse.PNG (34.58 KiB) Viewed 424 times


Hope it helps. If that's not what you're looking for, can you please post more specific example?