Skip to main content
Question

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

  • June 28, 2019
  • 5 replies
  • 73 views

Forum|alt.badge.img

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!

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

Forum|alt.badge.img

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?


Forum|alt.badge.img
  • Author
  • 9 replies
  • June 28, 2019

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


Forum|alt.badge.img
  • Author
  • 9 replies
  • June 28, 2019

Hi David,

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

 


Forum|alt.badge.img

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


Forum|alt.badge.img
  • Author
  • 9 replies
  • June 28, 2019

Hi David - You're a star!

Working like a dream....

Cheers