SAP Service Layer Login

This minimal utility workflow connects to the SAP Business One Service Layer API to verify login credentials and return the session ID. It's ideal for testing access or using as a sub-workflow to retrieve the B1SESSION token for other operations.

++⚙️ HOW IT WORKS:++ 🔹 1. Trigger Manually

The workflow is initiated using a Manual Trigger.

Ideal for testing or debugging credentials before automation.

🔹 2. Set SAP Login Data

The Set Login Data node defines four key input variables:

sap_url: Base URL of the SAP B1 Service Layer (e.g. https://sap-server:50000/b1s/v1/)

sap_username: SAP B1 username

sap_password: SAP B1 password

sap_companydb: SAP B1 Company DB name

🔹 3. Connect to SAP

A HTTP Request node performs a POST to the Login endpoint.

The body is structured as:

{ "UserName": "your_sap_username", "Password": "your_sap_password", "CompanyDB": "your_sap_companydb" }

If successful, the response contains a SessionId which is essential for authenticated requests.

🔹 4. Return Session or Error

The response is branched:

On success → the sessionID is extracted and returned.

On failure → the error message and status code are stored separately.

++🛠 SETUP STEPS:++ 1️⃣ Create SAP Service Layer Credentials Although this workflow uses manual inputs (via Set), it's best to define your connection details as environment variables for reuse:

SAP_URL=https://your-sap-host:50000/b1s/v1/ SAP_USER=your_sapuser SAP_PASSWORD=your_password SAP_COMPANY_DB=your_companyDB

Alternatively, update the Set Login Data node directly with your values.

2️⃣ Run the Workflow Click "Execute Workflow" in n8n.

Watch the response from SAP:

If successful: sessionID will be available in the Success node.

If failed: statusCode and errorMessage will be available in the Failed node.

++✅ USE CASES:++

• 🔄 Reusable Login Module Export this as a reusable sub-workflow for other SAP-integrated flows.

• 🔐 Credential Testing Tool Validate new environments, test credentials before deployment.