Skip to main content
Solved

Working nested GraphQL results in a JSON Call step in desktop

  • September 25, 2023
  • 2 replies
  • 185 views
M
Star Blazer L2
Forum|alt.badge.img+2

Hi,

There is a lot about GraphQL and JSON-call. But I have question on how to process nested GraphQL in a JSON and maintain integrity when using (nested) datastreams) in the JSON Call step in Ataccama (v13.x).

Below an example. There are profiles with path ($.data.catalogItem.publishedVersion.profilingConfigurationInstances.edges.node.publishedVersion.profiles.edges.node.@). And then a nested data-stream, which continus from this path (publishedVersion.attributeProfiles.edges.node). Each stream will give an output for the JSON-caller step. Now how do we maintain integrity between the streams/output files? So how can I refer from a sub-stream to a parent key, so I can later join the JSON-call output streams?



 

 

 

 

Best answer by AKislyakov

Hi @Marnix Wisselaar,

In the JSON Call step there is an option to set Shadow Columns which allows you to access columns from parent streams or from the input through a dot notation. Same as you did in your test plan. So you can pass the profileGID from parent stream to a child one.

 

2 replies

M
Star Blazer L2
Forum|alt.badge.img+2

Hi, 

 

Anyone? Enclosed a test.plan. How can the child be linked to its parent?

1 Attachments
A
A
Ataccamer
Forum|alt.badge.img+2
  • AKislyakovAtaccamer
  • Ataccamer
  • Answer
  • October 2, 2023

Hi @Marnix Wisselaar,

In the JSON Call step there is an option to set Shadow Columns which allows you to access columns from parent streams or from the input through a dot notation. Same as you did in your test plan. So you can pass the profileGID from parent stream to a child one.

 

A
Community Terms of Use & ConditionsCookie settingsAccessibility statement