Skip to main content

Notifications

Community site session details

Community site session details

Session Id : sTEdOqAA9igfM5nwqIBFaR
Power Automate - Using Connectors
Answered

creating custom connector from Postman for quickbooks

Like (0) ShareShare
ReportReport
Posted on 14 Jun 2019 16:24:56 by 4

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)PowerAppsRequest.PNG:

 

{
"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.

  • Suggested answer
    ShanPain Profile Picture
    2 on 29 Jan 2025 at 04:57:43
    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 Profile Picture
    4 on 17 Jun 2019 at 19:08:26
    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 Profile Picture
    4,556 on 15 Jun 2019 at 04:26:54
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Connectors

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 4 Super User 2025 Season 1

#2
VictorIvanidze Profile Picture

VictorIvanidze 2

#2
GI-06050833-0 Profile Picture

GI-06050833-0 2

Overall leaderboard

Featured topics

Loading started