QuickBooks - ExecuteRawSQL

POST

https://gateway.erpconnector.ca/api/QuickBooks/QBOAuth/ExecuteRawSQL/0

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 *****************

Body Params application/json

Examples

Responses

⚪0

text/plain

Request Example

Shell

JavaScript

Java

Swift

curl --location 'https://gateway.erpconnector.ca/api/QuickBooks/QBOAuth/ExecuteRawSQL/0' \
--header 'Authorization: Basic <encoded-value>' \
--header 'Content-Type: application/json' \
--data '"select * from Invoice WHERE TxnDate >= '\''2024-07-17'\''"'

QuickBooks - Auth - ConnectToQBORedirect

Relational Db - ExecuteRawSQL

QuickBooks - ExecuteRawSQL