Connector ideas

[Daniel Laskewitz (Laskewitz)]

Do yo have an idea for a connector? 💡 What actions and triggers should the connector have? Let us know in the comments below! 👇

[Kevin McDonnell (kevmcdonk)]

Canvas Apps connector for Azure Cosmos DB please!

[Troy Simeon Taylor (troystaylor)]

Which endpoints are missing?: https://docs.microsoft.com/en-us/connectors/documentdb/#actions

[Kevin McDonnell (kevmcdonk)]

Hmm, maybe things have changed and I have misunderstood the doc. At the top of that link, it has Power Apps listed as Not Available in the table of available places. When I tried previously, that was the case and you had to use Power Automate to call Cosmos DB and then call the flow from Power Apps.

[Daniel Laskewitz (Laskewitz)]

I found this forum reply that states it's not possible because Canvas Apps doesn't support unstructured data, so maybe that's the limitation. We won't be able to solve that with independent publisher connectors.

natalie-pienkowska, could you check if there are any plans to change support canvas apps with the Cosmos DB connector? Or is the limitation still blocking that?

[Kevin McDonnell (kevmcdonk)]

Ah, that would make sense

[Andrew Coates (coatsy)]

Could we revisit this now that we have ParseJSON()?

[lmheimendinger]

Retail system heartlandretail.com. Need to access (RO) fields like store sales, credits, returns, etc.

[Daniel Laskewitz (Laskewitz)]

lmheimendinger thanks for your suggestion. Will look into that one soon!

[Shane Young (ShanesCows)]

How about a Pandora API for those of us that listen to cool tunes?

[Troy Simeon Taylor (troystaylor)]

Certainly looks doable:
https://developer.pandora.com/docs/reference/graphql-api/overview/

[Daniel Laskewitz (Laskewitz)]

Great suggestion Shane Young (@ShanesCows). The "We're not accepting new access requests at this time. Please check again later." message at this page might be a problem to get this soon though.

[Carsten Groth (CarstenGroth)]

Supporting community to create more sustainability decision-making applications with low-code by adding connectors to Microsoft‘s Planetary Computer APIs
https://www.microsoft.com/en-us/ai/ai-for-earth-tech-resources#primaryR3

[Daniel Laskewitz (Laskewitz)]

Very cool suggestion! Certainly will dive into that! Thanks, Carsten!

[Troy Simeon Taylor (troystaylor)]

Hi Carsten,
The Species Classification API requires the content-type of application/octet-stream, which is only available in OpenAPI. Power Platform custom connectors currently have to be in the Swagger 2.0 format, so application/octet-stream is not available.
Both the Camera Trap and Land Cover Mapping APIs are both only open to invited users, so I'm not able to build out those connectors.

[Mimoune (djouallah)]

Google Sheet, at least for PowerQuery

[Rebekka Aalbers (RebekkaAalbers)]

He Mimoune (@djouallah) ,
PowerQuery uses a different connector framework. For Power Apps and Power Automate there already is a Google Sheets connector:
https://docs.microsoft.com/en-us/connectors/googlesheet/

[Max Murshed (mamurshe)]

Zoom
A user reported developing a custom connector for it using the swagger provided by Zoom. I requested him to publish as an Independent Publisher, but he probably wasn't interested. This should be a quick one to do.

[Troy Simeon Taylor (troystaylor)]

I can take a look at creating this one. Swagger is available at: https://marketplace.zoom.us/docs/api-reference/zoom-api/Zoom%20API.oas2.json

[Troy Simeon Taylor (troystaylor)]

Provided file says Swagger 2.0, but includes oneOf's which are part of OpenAPI 3.0, among other issues.

[Mary Myers (MMT0905)]

GroupMe connector

It would be nice to have a GroupMe connector that will allow for posting of messages, and GET of messages posted.

[Troy Simeon Taylor (troystaylor)]

If Daniel can't do it, I can add it to what I'm working on

[Mary Myers (MMT0905)]

oooh that would be good too!

[Daniel Laskewitz (Laskewitz)]

Mary Myers (@MMT0905) Sorry - a bit of a late reply. I started on it, but am not quite finished yet. Hoping to finish it the upcoming weekend or the weekend after.

[Mary Myers (MMT0905)]

EEEk That's so exciting Thank you!

[Troy Simeon Taylor (troystaylor)]

Daniel Laskewitz (@Laskewitz) how are you handling the implicit OAuth?

[Customery]

In my online course business, Customery Academy, I use Zapier to connect to the following apps:

Bonjoro - create task to record a personalised video to welcome new students
CloudConvert - turns a Google Slide into a PDF
ConvertKit - add a student as a new subscriber in my email marketing platform
New Zenler - my online course platform

Would be great to see connectors for more of the top email marketing (ConvertKit, Mailerlite, ActiveCampaign) and online course platforms (New Zenler, Teachable, Thinkific, Podia, Kartra, Kajabi).

[Troy Simeon Taylor (troystaylor)]

Hi Neil,
There are several great services here that could be made, either manually or from a Swagger definition file, if available. For those Zapier-connected services, I don't see an open API for Bonjoro or New Zenler, so those probably aren't possible.

Troy

[natalie-pienkowska]

Thanks for sharing! Adding some of these into https://github.com/microsoft/PowerPlatformConnectors/wiki/Top-Connector-Asks , except for the ones that Troy mentioned are likely Zapier-specific.

[Customery]

I know Zenler has an API, it's documented here. I'll ask the Bonjoro team to see if their API is public.

[Jim Duncan (sparkitect)]

ThoughtTrace

ThoughtTrace is a Document Understanding and Contract Analytics platform that uses pre-trained AI to read, organize, and manage the document workflows and processes critical to your business.

Triggers and actions for the Documents (and related) methods.

https://api.thoughttrace.com/swagger/index.html

[Troy Simeon Taylor (troystaylor)]

I see the definition they provide is OpenAPI 3.0.1, so this will require a bit more work since Power Automate connectors use Swagger 2.0.

[Troy Simeon Taylor (troystaylor)]

Can you please take a look at this file and use it to create a new custom connector?:
https://github.com/troystaylor/PowerPlatformConnectors/blob/ThoughtTrace/independent-publisher-connectors/ThoughtTrace/apiDefinition.swagger.json
I have signed up for a ThoughtTrace account, but as of now, I do not have a workspace I can test this connector against. Please keep in mind that you will need to configure the custom connector using OAuth 2.0, so you will need to obtain a client ID and secret. If it works for you, please post a screenshot with three successful actions. I will then work on cleaning up the Swagger file so that it is ready for submission to the Independent Publisher Connector program.

[Jim Duncan (sparkitect)]

On it...
(between meetings)

[Jim Duncan (sparkitect)]

Stuck here attempting to create a connection:

(I'm new here, btw ;)

[Troy Simeon Taylor (troystaylor)]

You will need to register the following as the redirect URL within ThoughtTrace OAuth settings:
https://global.consent.azure-apim.net/redirect

[Sameer Chabungbam (schabungbam)]

Workday
Got requests from customers on this one. The one we have internally is more complex than needed (it is what we call as 'codeful') connector.

[Matthew Collinge (mcombp)]

Zoho CRM API V2.0 please
https://www.zoho.com/crm/developer/docs/api/v2/modules-api.html
I've created this successfully using Postman Collection. This fails when importing the Postman Collection into a Custom Connector. The Request fails with the Response Body of:

{ "code": "INVALID_REQUEST",
"details": {},
"message": "unable to process your request. please verify whether you have entered proper method name, parameter and parameter values.",
"status": "error"}

[Daniel Laskewitz (Laskewitz)]

IBM Watson

IBM has a bunch of awesome cognitive services APIs. Would be cool to have them available in the Power Platform as well.

IBM Watson Documentation

[Daniel Laskewitz (Laskewitz)]

Troy Simeon Taylor (@troystaylor) If you're looking for more APIs to fill your backlog... 😁

[Troy Simeon Taylor (troystaylor)]

Always!

[Martin Dreyer (martin-dreyer-teck)]

A DataBricks query connector would be great, now that the SQL Execution REST API is in preview.

Actions should mirror these

• Execute Statement | POST /api/2.0/sql/statements/
• Get Status & Results | GET /api/2.0/sql/statements/{token}
• Cancel Execution | POST /api/2.0/sql/statements/{token}/cancel

[Chris Garty (ChrisGarty)]

Documentation for Top Connector Asks is here: https://github.com/microsoft/PowerPlatformConnectors/wiki/Top-Connector-Asks
Keep suggesting connectors to provide additions to that list!

[lmheimendinger]

Sorry not following your point. From: Andrew Coates ***@***.***> Sent: Monday, May 1, 2023 3:29 PM To: microsoft/PowerPlatformConnectors ***@***.***> Cc: Larry Heimendinger ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/PowerPlatformConnectors] Connector ideas (Discussion #1014) Could we revisit this now that we have ParseJSON()? — Reply to this email directly, view it on GitHub<#1014 (reply in thread)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/APUTTT62K2Q7F2DBJK42GX3XEA2JPANCNFSM5BSA3HEA>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

[stevesint]

hello

power automate connector, telegram with "sendmediagroup" option, please!