Integration Technologies - JDE1 (MOSC)

MOSC Banner

Need help with Custom JRUBY code to parse JSON input from MS Power Automate

Application: JDE E1 9.2

Tools Release: 9.2.6.3

AIS & HTML Servers Tools Release: 9.2.6.4 06-09-2022_02_04

Orchestrator "MSAUTOMATEIN" is being invoked by MS Power Automate using REST API call "/jderest/v3/orchestrator/MSAUTOMATEIN" and passing JSON as specified below

{
  "ProformaInvoice": [
    {
      "UniqueID": 0,
      "CompanyKey": "string",
      "DocumentType": "string",
      "DocumentNumber": 0,
      "AddressNumber": 0,
      "AmountGross": 0,
      "VendorInvoiceNumber": "string"
    }
  ],
  "ApprovalStatusInfo": [
    {
      "ApprovalActionCode": "string",
      "ApprovalMessage": "string"
    }
  ]
}

I added Variables in "Inputs and Values" of the Start step of Orchestrator.

I added Custom f(x) step "MAPJSON" to parse JSON Array and assign it to variables. So that can use output Variables of "MAPJSON" to the Report service request "EXENEXTSTEPS" by passing variables to Report Interconnect (RI)

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