Question

HttpCaller Json - how to process each page individually in FME?

  • 28 June 2019
  • 5 replies
  • 12 views

Badge

Hi,

I’m using HttpCaller for a REST JSON get call.

On the response I use JSONFlattener & JSON Fragmenter with query json["{data}"] giving the following 2 pages-

(personal data redacted for this post)

 

data{0}.applicationId (encoded: utf-8)

data{0}.applicationStatus (encoded: utf-8)

data{0}.applicationTypeCode (encoded: utf-8)

data{0}.dob (encoded: utf-8)

data{0}.eligibilityCode (encoded: utf-8)

data{0}.name (encoded: utf-8)

data{0}.nino (encoded: utf-8)

data{0}.partyTypeCode (encoded: utf-8)

data{0}.submissionDate (encoded: utf-8)

data{1}.applicationId (encoded: utf-8)

data{1}.applicationStatus (encoded: utf-8)

data{1}.applicationTypeCode (encoded: utf-8)

data{1}.dob (encoded: utf-8)

data{1}.eligibilityCode (encoded: utf-8)

data{1}.name (encoded: utf-8)

data{1}.nino (encoded: utf-16)

data{1}.partyTypeCode (encoded: utf-8)

data{1}.submissionDate (encoded: utf-8)

 

(Pagination set to max 50 pages)

 

How can I process each page individually as I’ll be using the attributes from each page to then populate a XMLTemplater to POST a SOAP request?

 

Thanks!

 


5 replies

Badge

If I've understood, could you not use a ListExploder on data{} to produce a single feature for each page outputted and then an AttributeExposer?

Badge

If I've understood, could you not use a ListExploder on data{} to produce a single feature for each page outputted and then an AttributeExposer?

Cheers David - I'll give that a go...Thanks

Badge

Hi David,

The "response_body" is not available for the ListExpoder to pass the json response to -

 

Badge

Hi David,

The "response_body" is not available for the ListExpoder to pass the json response to -

 

Try exposing the attribute data{} in the JSON fragmenter or flattener

Badge

Hi David - You're a star!

Working like a dream....

Cheers

Reply