Connect to ConnectWise using Power Automate

%3CLINGO-SUB%20id%3D%22lingo-sub-1494256%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494256%22%20slang%3D%22en-US%22%3EDo%20you%20get%20any%20errors%20back%20from%20the%20API%20call%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497271%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497271%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3EI%20am%20getting%20error%20codes%20301%2C%20400%2C%20401%2C%20500%2C%20and%20Authentication%20error%20some%20times%20for%20different%20URLs.%20Not%20sure%20where%20I%20am%20making%20mistake%2C%20either%20in%20URL%20format%20or%20authentication%20or%20in%20headers.%20Please%20see%20attached%20image.%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1490839%22%20slang%3D%22en-US%22%3EConnect%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1490839%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20consume%20ConnectWise%20APIs%20from%20Power%20Automate%20%2C%26nbsp%3B%20I%20tried%20to%20follow%20ConnectWise%20API%20documentation%20for%20the%20same%20but%20was%20not%20successful.%20Anybody%20have%20tried%20consuming%20ConnectWise%20APIs%20using%20Power%20Automate%20HTTP%20connector%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1490839%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1770085%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1770085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285444%22%20target%3D%22_blank%22%3E%40PriyaRaskar%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EI'm%20sure%20you've%20figured%20the%20Issue%20out%20by%20now.%3CBR%20%2F%3EHowever%2C%20I%20thought%20I%20would%20post%20a%20reply%2C%20in%20case%20others%20come%20looking%20for%20an%20answer.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EPerhaps%20if%20you%20replace%20your%20%22URI%22%20w%2F%20the%20following%2C%20it%20might%20help.%3CBR%20%2F%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fapi-na.myconnectwise.net%2Fv4_6_release%2Fapis%2F3.0%2Fcompany%2Fcontacts%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi-na.myconnectwise.net%2Fv4_6_release%2Fapis%2F3.0%2Fcompany%2Fcontacts%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3ENOTES%3A%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3E%22%3CSTRONG%3Ehttp%3A%2F%2F%3C%2FSTRONG%3E%22replaced%20w%2F%20%22%3CSTRONG%3Ehttps%3A%2F%2F%3C%2FSTRONG%3E%22%3CSTRONG%3E%3CBR%20%2F%3E%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3E%22%3CSTRONG%3ECompanyName%3C%2FSTRONG%3E%22replaced%20w%2F%20%22%3CSTRONG%3Eapis%3C%2FSTRONG%3E%22%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EI%20would%20also%20like%20to%20recommend%20that%20anyone%20interested%20in%20working%20with%20APIs%2C%20consider%20utilizing%20an%20API%20Tool%20(such%20as%20%22%3CA%20href%3D%22https%3A%2F%2Fwww.postman.com%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EPostman%3C%2FA%3E%22)%2C%20to%20Test%20their%20API%20Calls.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20this%20information%20helps%20someone%20out.%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850515%22%20slang%3D%22en-US%22%3ERe%3A%20Connect%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850515%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F285444%22%20target%3D%22_blank%22%3E%40PriyaRaskar%3C%2FA%3E%26nbsp%3Bcan%20i%20check%20which%20connector%20you%20used%20as%20i%20am%20trying%20to%20find%20HTTP%20connector%20and%20it's%20not%20showing%20up%20for%20me%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1850516%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1850516%22%20slang%3D%22en-US%22%3EHi%20Thanks%20for%20that%20info%20can%20you%20please%20let%20me%20know%20which%20connector%20i%20can%20use%20%3F%20as%20i%20can't%20find%20HTTP%20connector%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920407%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920407%22%20slang%3D%22en-US%22%3EI%E2%80%99ve%20managed%20to%20do%20this%20by%20building%20a%20custom%20connector%20with%20predefined%20methods.%20It%E2%80%99s%20been%20working%20great%20for%20me%2C%20but%20took%20a%20lot%20of%20trial%20and%20error.%20If%20you%20PM%20me%20I%E2%80%99d%20be%20happy%20to%20send%20you%20an%20export%20of%20the%20connector%20so%20you%20can%20import%20it%2C%20and%20I%20can%20show%20you%20how%20to%20build%20more%20methods%20for%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2117251%22%20slang%3D%22en-US%22%3ERe%3A%20Connet%20to%20ConnectWise%20using%20Power%20Automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117251%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877134%22%20target%3D%22_blank%22%3E%40Bradleylacroix%3C%2FA%3E%20-%20I%20am%20new%20powerautomate%20and%20working%20on%20a%20project%20to%20connect%20to%20my%20CW%20server.%20Struggling%20to%20get%20this%20to%20work.%20Ca%20you%20send%20me%20an%20export%20of%20the%20connector%20so%20I%20can%20disect%20and%20investigate.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I am trying to consume ConnectWise APIs from Power Automate ,  I tried to follow ConnectWise API documentation for the same but was not successful. Anybody have tried consuming ConnectWise APIs using Power Automate HTTP connector? 

7 Replies
Do you get any errors back from the API call?

@Steve KnutsonI am getting error codes 301, 400, 401, 500, and Authentication error some times for different URLs. Not sure where I am making mistake, either in URL format or authentication or in headers. Please see attached image.

 

 

@PriyaRaskar 
I'm sure you've figured the Issue out by now.
However, I thought I would post a reply, in case others come looking for an answer.

Perhaps if you replace your "URI" w/ the following, it might help.
https://api-na.myconnectwise.net/v4_6_release/apis/3.0/company/contacts

 

NOTES:

  • "http://"replaced w/ "https://"
  • "CompanyName"replaced w/ "apis"

I would also like to recommend that anyone interested in working with APIs, consider utilizing an API Tool (such as "Postman"), to Test their API Calls.

I hope this information helps someone out.

Hi @PriyaRaskar can i check which connector you used as i am trying to find HTTP connector and it's not showing up for me 

Hi Thanks for that info can you please let me know which connector i can use ? as i can't find HTTP connector
I’ve managed to do this by building a custom connector with predefined methods. It’s been working great for me, but took a lot of trial and error. If you PM me I’d be happy to send you an export of the connector so you can import it, and I can show you how to build more methods for it.
@Bradleylacroix - I am new powerautomate and working on a project to connect to my CW server. Struggling to get this to work. Ca you send me an export of the connector so I can disect and investigate.