REST API CALL+JSON

[Former Member]

Hi A ll,

Please let me know how to call the REST API from SAP B1if.

Actually, the scenario is I want to integrate SAP B1 with Zoho.

The scenario is like that whenever Customer Master Data,Customer Contacts,Customer Address(Ship to and Bill to Separetley),Sales Invoice which are created in SAP B1 it should be created in Zoho. So for this, i have Zoho REST API and through this API i will send the customer details to Zoho.

All Integration i need real time only.

there are some calculated fields and database fields i need to pick.

Input zoho required in Json format

If you have any documents on this then please let me know.

[former_member416544]

Hi Krishnan,

Dd you get any solution?

[former_member390407 · Accepted solution]

Yadav,

It's up to you what to use, both HTTP Outbound and HTTP atom will let you achieve the goal. The difference is that it's easier to debug and you can do other stuff after posting to HTTP if you use the atom. But it's clearer and more logical to use outbound if your business-logic finishes on the HTTP call.

About JSON preparation: please go through the document Help -> Documents -> Conversion XML - JSON. The part from the document:

In HTTP inbound and outbound, set the payload type to JSON (pltype="jso") or
(pltype="json") to receive or hand over a message payload in JSON format. In the inbound
phase, the integration framework recognizes the JSON format and converts it to XML. In the
outbound phase, the integration framework automatically provides the payload in JSON format.
If you need a JSON representation in the processing phase, use the Conversion XML to JSON
atom.

[former_member390407]

Hello Yadav,

As I saw you already asked it twice and got no reply. I assume it's because your question is too generic and doesn't reflect a question at all. What exactly do you want from the community? To share an example of the scenario? You didn't mention what you'd done before you posted the question, so I don't think people treat your question seriously. Also you didn't even mention the version of SAP and B1IF you use. If you are looking for the documentation you can find it in the B1IF Help section. There are documents for SAP B1 event inbound and HTTP outbound, probably that's what you are looking for.

[Former Member]

Hi Sergei,

thanks for your fast response

I am using SAP B1 9.3 pl 03 and B1IF Version : 1.22.15.1.

I tried to create SAP B1 Event Inbound .i want to pass key value field (eg:Carcode for Business partner,DocEntry for Sales Order) to SQL query and the result i need to update in JSON Format.sample JSON format is

"data": [{
"Owner": {
"name": "TEST",
"id": "2023207000000100012"
},
"Name": "Test Customer", //Address Name
"Billing_Country": "India",
"Address_Type": "B",
"Account_Name": {
"name": "Test",
"id": "2023207000001498484"
},
"Billing_Street": "TEST",
"Billing_Code": "500040",
"Billing_City": "Chennai",
"Billing_State": "Tamil Nadu",
"GST_Number": "TEST123",
"SAP_Code": "C001023"
}]

For this whether I need to use HTTP call atom or HTTP outbound?

How to pass query result to http call atom?

thanks and Regards,

yadav