Integration Technologies - JDE1 (MOSC)

MOSC Banner

How to create a nested JSON output using data requests and iterate over

edited Oct 17, 2022 7:48AM in Integration Technologies - JDE1 (MOSC) 2 commentsQuestion

E1 9.2.5.4 E920

Goal: select all items a customer purchased for each item list all serial numbers

DataRequest1: input customer code; retrieve all items, their description and manufacturer; Data Set Variable Name = Items

DataRequest2: input item; retrieve all serial numbers and warehouse code

Orchestration1: input item; call DataRequest2; return all grid rows

Connector to Orchestration1

Orchestration2: input customer code; call DataRequest1; call Connector; iterate over Items ; return all grid rows

End result is all the items from DataRequest1, followed by all the serial numbers for all the items

What I want is

Item1

Description1

Serial1

Serial2

Item2

Description2

Serial3

Serial4


What I get is

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center