Anyone try LAC Salesforce Connector to create API? We can not even test the connection with sandbox upon creation of API with salesforce driver from production installation. The same credential and token works when using mulesoft salesforce connector.
A defect has been logged for this In Live API Creator 3.1x, in the mean time here is the workaround to connect to Salesforce Sandbox instance and getting error after clicking on Test button.
Log Into LiveAPI -> Create New API -> Empty API -> Proceed to API Properties -> Integrate (Data Sources) -> Add -> Pick Database type: Salesforce -> fill in all required fields.
Modify jdbcurl: jdbc:salesforce:SecurityToken=<sec_token>;useSandbox=TRUE