Hi @manohar ,
How I see it when I use the json file, There are two same ‘data’ objects. One with only orderline and one with the other objects inside so that means that some ‘data’ objects contain the orderline and some does not.
When i try to extend the ‘data’ object with the orderline and rename it. Only the second data object gets the new orderlines object because that ‘data’ object only contains the Order-line the other Data object just gets a ‘null’ value in the orderlines object field.
I don’t know where you get your data from but it seems that not every data object has the order-line.
pipeline below for more explanation
community_pipeline_V1.0_2022_11_10.slp (124.9 KB)
Hi @JensDeveloper appreciate your help.
In fact, the orderline is not coming in the ‘data’ object. I just transformed it as below to have it part of the data thinking it might help, like using join as below
‘data’ with out orderlines is coming from different snap and orderlines are coming from different snap
please find attached the input jsons and the json that I am trying to achive as final.
Thank you for you help,
Manohar
input_json2_with_orderlines.json (82.4 KB)
input_json1_with_outorderlines.json (23.2 KB)
Final_Expected_Json_structure.json (2.4 KB)
A Groundplex machine needs to be have network access to the endpoint from which data needs to be accessed. If the endpoint access is restricted, starting a Groundplex in the same network as the endpoint is the easiest solution. Since the Groundplex needs only outbound access to the SnapLogic control plane, the networking requirements are easiest to satisfy in this setup. The communication to the control plane can be direct, through a HTTP proxy or through a firewall whitelist.
If direct network access to the endpoint is not available from the Groundplex machine, it is possible to install third party or open source VPN software on the Groundplex node and enable connectivity, assuming there is a VPN server running. This would have to be done by the customer’s network operations team, this is not part of SnapLogic functionality.
