Relational Db - ExecuteRawSQL

POST

https://gateway.erpconnector.ca/api/RelationalDatabase/ExecuteQuery

QuickBooks ExecuteRawSQL

This endpoint allows you to execute raw SQL queries for QuickBooks.

Request Body

The request body should be in raw format and contain the SQL query to be executed.

Response

The response will contain the result of the executed SQL query.

Request

Authorization

Send your HTTP requests with an

Authorization

header that contains the word Basic followed by a space and a base64-encoded string username:password

Example:

Authorization: Basic *****************

Header Params

Body Params application/json

Examples

Responses

🟢200

application/json

Bodyapplication/json

Request Example

Shell

JavaScript

Java

Swift

curl --location 'https://gateway.erpconnector.ca/api/RelationalDatabase/ExecuteQuery' \
--header 'COMPANY_ID: 2' \
--header 'Authorization: Basic <encoded-value>' \
--header 'Content-Type: application/json' \
--data '"select * from INFORMATION_SCHEMA.TABLES"'

Response Example

{}

QuickBooks - ExecuteRawSQL

Test ERP Connection

Relational Db - ExecuteRawSQL

QuickBooks ExecuteRawSQL#

Request Body#

Response#

Request

Responses

QuickBooks ExecuteRawSQL

Request Body

Response