SAP and Zoho Integration for Seamless Data Management

Objective

The objective of integrating SAP with Zoho is to streamline business processes by enabling seamless data flow between the two platforms. This integration aims to enhance operational efficiency by automating tasks such as sales, Expense Management. It allows users to create, update, and delete SAP records directly from Zoho. Additionally, it helps businesses make informed decisions through unified insights, supporting scalability and improved customer experiences.

Steps to Create a Record Using SAP API Endpoint

Enter Request URL:

In the "Enter Request URL" text box, input the SAP endpoint URL where the record will be created.
Example: https://your-sap-endpoint-url.com/resource.

Select Request Method:

Choose the "POST" method from the dropdown menu.
The POST method is used to create a new record on the server.

Authorization (Basic Auth)

Authentication Type:

Use Basic Auth for authentication.

Username:

Enter the username or token provided by the SAP service for authentication.

Password:

Enter the corresponding password associated with the username.

How Basic Auth Works:

When the request is sent, the system automatically generates an Authorization header.
This header includes the username and password encoded in Base64 format.

Authorization Header Format:

Authorization: Basic <Base64-encoded-username:password>

To create a record we need to pass data in the body section.

Body:

{
    "Request_Data": {
        "Company_Code": "1800",
        "Document_Type": "KZ",
        "Document_Date": "2023-09-29",
        "Posting_Date": "2023-09-29",
        "Fiscal_Year": "2023",
        "Currency": "INR",
        "Reference": "ZOHO",
        "Item": [
            {
                "Vendor_Code": "4000000064",
                "Vendor_SPL_GL": "A",
                "GL_Account": "",
                "Posting_Key": "21",
                "Amount_in_DC": "5000",
                "Amount_in_LC": "5000",
                "Cost_Center": "",
                "Profit_Center": "",
                "Account_Type": "K",
                "Debit_Credit_Indicator": "S"
            },{
                "Vendor_Code": "",
                "Vendor_SPL_GL": "",
                "GL_Account": "16130022",
                "Posting_Key": "50",
                "Amount_in_DC": "5000",
                "Amount_in_LC": "5000",
                "Cost_Center": "",
                "Profit_Center": "1800",
                "Account_Type": "S",
                "Debit_Credit_Indicator": "H"
            },
            {
                "Vendor_Code": "",
                "Vendor_SPL_GL": "",
                "GL_Account": "16130022",
                "Posting_Key": "50",
                "Amount_in_DC": "5000",
                "Amount_in_LC": "5000",
                "Cost_Center": "",
                "Profit_Center": "1800",
                "Account_Type": "S",
                "Debit_Credit_Indicator": "H"
            }
        ]
    }
}

By clicking the Send button, you will receive a response.

Note: Here’s an example of creating a record during integration with SAP. For now, I have used Postman, but the same steps can be followed in the Zoho application using the supported Deluge language.

This demonstrates the process of creating records in SAP by sending an HTTP POST request, similar to how Postman operates. In Deluge, you would construct the same request by defining headers, setting the body, and handling the response accordingly to ensure proper integration between Zoho and SAP.