Step-1) In “ERP Development” there is one form named “Create API” click on it.

Step-2) As the below pages open enter your “CloudCode”.

Step-3) After selecting the “CloudCode” select the “SQLID” on which the SQl is present.

Step-4) After selecting “SQLID” click on “Generate” button to generate the API.

Step-5) After clicking on “Generate” button your API is created now you have to enter the required parameters in ”Input Column Value” (NOTE*:- You have to separate each parameter with “@j@”). After putting the parameters again click on the “Generate” button to your parameters in the API.

Step-6) You can see the SQL Query that is present on that field and the API URL.

There are two types of API URL:-

1. External :- Which will work without login and would be required in Apps.

2. Internal:- Which does not require a token, so you can check the API by firing it on the browser but you have to be logged in to that server.

Error Message:-

The below ERROR Message means that there is no SQL present in the selected SQLID.