United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
uv_finance_argano
Level 1
posted
‎July 03, 2023 09:50 PM
last updated ‎July 03, 2023 4:50 AM

ADF + API query

Hi, I'm using the Azure Data Factory to get data for the department.

I'm using the API with the query option, as the parameter I'm sending the next "/v3/company/XXXXXXXXXXXXXXX/query?query=select * from Department"

 

Seems, the spaces are the problem, cause ADF formatted them like character %20 and as the result I getting "https://quickbooks.api.intuit.com/v3/company/XXXXXXXXXXXXXXX/query=select%20*%20from%20Department" and it is not supported.

 

Could you please advise the proper way? 

Thanks.

 

 

Solved
Reply
Best answer July 03, 2023
Solved

Best Answers
MichelleBh
Moderator
Moderator
‎July 03, 2023 10:47 PM

ADF + API query

We're here to help you, uv_finance.

 

I'll route you to the proper support who can help you further with ADF + API query. This way, you can get back where you left off. 

 

In this manner, I suggest contacting our Intuit developer directly. Our developer can further examine the error in a safe place and provide troubleshooting steps to resolve the error. 

 

To contact them, follow the steps below: 

 

  1. Go to Intuit Developer Support page and click your QuickBooks version in the list.  
  2. Click Ask a Question and enter your concern in the box. 
  3. If you don't have an account, the Create account page will open after clicking the Ask a Question. 
  4. Follow the on-screen instructions. 

 

Also, if you have some How do I concern with QuickBooks Online, you can visit our Help Articles page.

 

Remember that you can always ask me about any topics or other processes within QuickBooks. I'm always ready to work with you again. Take care.

View solution in original post

Reply
1 Comment 1
MichelleBh
Moderator
Moderator
‎July 03, 2023 10:47 PM

ADF + API query

We're here to help you, uv_finance.

 

I'll route you to the proper support who can help you further with ADF + API query. This way, you can get back where you left off. 

 

In this manner, I suggest contacting our Intuit developer directly. Our developer can further examine the error in a safe place and provide troubleshooting steps to resolve the error. 

 

To contact them, follow the steps below: 

 

  1. Go to Intuit Developer Support page and click your QuickBooks version in the list.  
  2. Click Ask a Question and enter your concern in the box. 
  3. If you don't have an account, the Create account page will open after clicking the Ask a Question. 
  4. Follow the on-screen instructions. 

 

Also, if you have some How do I concern with QuickBooks Online, you can visit our Help Articles page.

 

Remember that you can always ask me about any topics or other processes within QuickBooks. I'm always ready to work with you again. Take care.

Reply