B2B Integration

 View Only
Expand all | Collapse all

Json API Integration Support with SI 5.2.6

  • 1.  Json API Integration Support with SI 5.2.6

    Posted Tue October 06, 2020 03:53 PM
    Hello All,

    We are using Sterling Integrator 5.2.6.2 and we come across one Integration where we need to call REST API with only Json format supported.
    I know from SI 6 onwards there is XMLtoJSON and JSONtoXML service by default with Product but in current SI version we have is there any recommended way by which we can achieve this integration with REST API in json format ?
    Kindly help.
    Thank you.

    //Kartik

    ------------------------------
    Kartik Patel
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Json API Integration Support with SI 5.2.6

    Posted Wed October 07, 2020 02:36 AM
    Hi Kartik,
    as you correctly indicated, XMLroJSON service, to transform an XML to a JSON and vice versa is available from 6 onwards.
    In 5.2.x you can use the map editor to  have in input an XML file  and in output a CSV one (or vice versa, depending on the transformation you want to achieve). In the CSV file the filed separator will be the ":". You will need to play with the brackets "{}" but it's achievable.
    Another way when changing from XML to JSON is to use an XSLT to do the job.
    Best regards
    Emiliano Pacelli

    ------------------------------
    Emiliano Pacelli
    ------------------------------