Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  How to upload data from JSON file

    Posted 10-21-2020 09:38
      |   view attached
    Hello Community,

    Need your advise if it's possible to map/upload data directly from a JSON file without convert to text or csv/excel file

    Does it require a specific License ? How to proceed exactly ? Have you a specific procedure or tutorial based on api that can handle that ?as if we read existing help litterature about studio 12.X version this format is supposed to be support in native with Winshuttle.

    Manny thanks in advance for your help

    Regards

    ------------------------------
    jerome gaden | [Logistic analyst]
    Atlas Copco Power Tools Distribution N.V. | +33 02.40.80.20.63
    ------------------------------

    Attachment(s)

    txt
    6150700113-config-properties.txt   1 KB 1 version


  • 2.  RE: How to upload data from JSON file

    Employee
    Posted 10-28-2020 09:50
    Hi Jerome

    I'm not aware of a way to do so.  You can import a JSON file into Excel, for example, and use transformation options to create a table with columns.   I just walked thru it and it was quite easy to do.
    Choose Data -> import from File -> choose JSON -> choose your file
    Once in the data connection editor window, I converted to table and transposed it, so that I had columns of data.  You'd only need to do that if you were loading more than one object in SAP.
     I had to move the column headers and then ended up with this:
    HTH
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------