Answered

creating custom connector from Postman for quickbooks

(0) Share

Report

Posted on by RyanBuz

I followed the quickbooks to postman setup and the api perfectly calls the quickbooks request and response. I have exported the json for postman into powerapps. I have followed same setup for powerapps as I used for postman. However, in the path for the definitions the company ID is not showing the actual company ID as I had used in the postman setup. I would manually add the company ID myself but the option is greyed out. Does anyone have any suggestions or avenues I should try to solve this? As it stands now, I get an error that states (picture attached for more detail and code below):

{
"warnings": null,
"intuitObject": null,
"fault": {
"error": [
{
"message": "message=BadRequest; errorCode=003202; statusCode=400",
"detail": "Illegal character in path at index 52: https://c50.sandbox.qbo.intuit.com/qbo50/v3/company/{{companyid}}/query",
"code": "3202",
"element": null
}
],
"type": "VALIDATION"
},
"report": null,
"queryResponse": null,
"batchItemResponse": [],
"attachableResponse": [],
"syncErrorResponse": null,
"requestId": null,
"time": 1560464718594,
"status": null,
"cdcresponse": []
}

As you can see, the companyID is not populating...and I am at a loss for where to troubleshoot since the call/response worked in postman and not sure why it is not populating when I bring in the postman json.

Thanks for any input.

All responses (3)

Answers (1)

Suggested answer

ShanPain 2 on at

Like (0)

Report

creating custom connector from Postman for quickbooks

Hey, I know this post is 5 years old and I hope you managed to find a solution. But, just in case anybody else has the same question, here is what worked for me:

In your definitions page there should be a toggle to activate "Swagger Editor"

Once that switch is activated, you go into editor and manually delete the "%7B%7Bcompanyid%7D%7D" (found in line 14 in my screenshot) and replace it with your actual company ID.

Hope this helps!
RyanBuz 4 on at

Like (0)

Report

Re: creating custom connector from Postman for quickbooks

I followed the postman/quickbooks api link you posted, that was what I initially started with and went through all the steps there. In Postman, the api call worked and returned the expected response. I then exported the Postman json for the successful call/response and I was using that for the powerapps section. Somewhere in that process, it drops the companyID in the POST call on powerapps. Since that link is hardcoded, I am unable to update that on my end. So I am not really sure where to go from there.

Thank you for your reply.
Verified answer

Brad_Groux 4,556 on at

Like (0)

Report

Re: creating custom connector from Postman for quickbooks

This looks to be an issue on the side of the Quickbooks App, as all that the Flow connector is doing is using HTTP requests to return the values provided by the Quickbooks API that was created and passed through from Postman.

I imagine that you've followed the steps for setting up a Postman API and Quickbooks developer app outlined by Quickbooks support here? Specifically, Configuring the PostMan authorization header?

Also, I notice that you are utilzing the app's sandbox area, which is generally used for testing - have you confirmed with Quickbooks support that you can update/change the company ID in sandbox mode?

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!