Cloud Inventory® Documentation

Load Media Objects to the Database

Note:This process assumes the user has a comprehensive familiarity with Oracle and database troubleshooting.

Notes for the JSON String

The user will have to determine the media object data structure (the GTxxxx) which is entered into the GTObjectName field. The user will also have to determine the key for that record. In some instances, it will be a simple key (shipment number or short item number, for instance).
If a line number needs to be formatted in a particular way (if it is part of the key), it needs to be formatted prior to passing it into the Key field. For instance, the sales order detail line number needs to be passed in as 1.000 (as it does when done through JDE). If it is not passed in with the decimal formatting (i.e.: passing it in as 1), it will not appear on the application, but it will be in the F00165.
Cloud Inventory® does not validate any of the key data.

To complete the JSON string, the user needs to know:

Name of the object
Text Key
Where the media object is being assigned

Gather the Components for the JSON

Check the F00165 table for a similar media object to the one you want to load. Use the information in this table to find the components for your JSON string:

Text Key
Media Object assignment location

Check the Media Objects storage table (F00165) and find a media object similar to the one you plan to load.
Once you find a sample media object, note the Text Key of the file in the GDTXKY column.
Note the object's location in the GDOBNM column.

Create the JSON String

Open a text editing app such as Notepad++.

Structure your string as shown in the sample below (underlined, italicized text indicates the information that will change depending on your specific media object being uploaded):

Example

{    
    "moStructure":"ABGT",
    "moKey":[
        "9955"
    ],
    "formName":"P4210_W4210A",
    "version":"ZJDE0001",
    "file":{
        "fileName":"dog.jpg",
        "fileLocation":"C:\\test\\dog.jpg",
        "itemName":"AbbyTest_Dog",
        "sequence":0        
    }
}

Optional: flatten your code to make it easier to copy and paste.
Save your text file as a .json file type.

Copy the JSON String to Cloud Inventory®

Open Cloud Inventory® Service Definition.
In the BODY section of the Service Definition window, load the JSON and the media object files.
In the bottom right area of the Service Definition window, select the Save as JSON file option.
Select the Save and Text button.

Oracle Documentation

For further information, please refer to the Oracle documentation regarding their process.

https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/rest-api/op-v2-file-upload-post.html

Mobile Enterprise Platform

Load Media Objects to the Database

Load Media Objects to the Database

Notes for the JSON String

Gather the Components for the JSON

Create the JSON String

Copy the JSON String to Cloud Inventory®

Oracle Documentation