SAP Business One V10 SQL API

[RuanDuPreez]

Good Day

We are busy moving from SAP B1 V8 to V10 SQL Server. Is there a REST API available where I can call procedures via HTTP REST interface on SQL Server version? We write our own 3rd party programs. I can only see that there is a REST API on HANA and not SQL. Please can someone guide me in the right direction. 

Regards

Ruan

[ANKIT_CHAUHAN · Accepted solution]

Hi RuanDuPreez,

If you are looking in Service Layer context, I would like to inform you that Service Layer works on MS SQL (Windows) version as well in SAP Business One version 10.0.

Install Service Layer using SAP Business One Component Wizard and try to access the following link: https://SLDSERVER:50000.

It will provide you the list of all the APIs available.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[RuanDuPreez · Accepted solution]

Thanks for your help. Will I be able to call the API remotely?

[RuanDuPreez · Accepted solution]

I have a public IP but cannot access https://PUBLICIP:50000. Is there a different setting that I need to check?

[ANKIT_CHAUHAN · Accepted solution]

Hi RuanDuPreez,

If you have installed Service Layer correctly, the link to access it will appear in the Services tab of System Landscape Directory (SLD).

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[RuanDuPreez · Accepted solution]

Hi ANKIT_CHAUHAN

I can access port 50000 on the server where SAP was installed but not from my pc with the public ip.