http connector content string

How-to(s), solutions to common problems, pearls of wisdom

thomas7467
Posts: 1
Joined: Wed Feb 22, 2017 2:38 pm

http connector content string

Postby thomas7467 » Wed Feb 22, 2017 3:37 pm

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

svecp
Posts: 25
Joined: Wed Nov 09, 2016 11:51 pm
Location: 2111 Wilson Blvd., Arlington VA 22201
Contact:

Re: http connector content string

Postby svecp » Fri Feb 24, 2017 7:24 pm

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 422 times


Hope it helps. If that's not what you're looking for, can you please post more specific example?
--
Pavel Švec | CloverETL | Sales Engineer | 2111 Wilson Blvd | Suite 320 | Arlington, VA 22201


cron