Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Cloud gateway for MySQL in Power Automate

(0) ShareShare
ReportReport
Posted on by 6

Hi,

 

I am looking for creating a connection to MySQL in PowerAutomate. However, it asks for on-premise gateway, is there any way to have it as cloud gateway?

 

I am connecting with WordPress site whose backend is MySQL.

 

Thanks!

  • DivyaniR Profile Picture
    DivyaniR 6 on at
    Re: Cloud gateway for MySQL in Power Automate

    Hi Gopala,

     

    I am creating custom connector for woocommerce using different ways,

     

    1) Starting from blank, it gives me below error  in Response:

     

    {
     "code": "woocommerce_rest_cannot_view",
     "message": "Sorry, you cannot list resources.",
     "data": {
     "status": 401
     }
    }

     

    I am wondering what to provide in Security for authentication for woocommerce.

     

    2) Creating from Open API URL with below link :

     

    "https://example.org/wp-json/wc/v3/orders/?consumer_key&consumer_secret"

     

    it's giving me error :

     

    Specified swagger has the following errors: 'Definition is not valid. Error: 'Error : 0 : The property '0' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 1 : The property '1' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 2 : The property '2' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 3 : The property '3' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 4 : The property '4' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 5 : The property '5' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 6 : The property '6' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 7 : The property '7' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 8 : The property '8' is not valid. If this property is an extension, its name must begin with "x-".
     ## Error : 9 : The property '9' is not valid. If this property is an extension, its name must begin with "x-".
    '

     and not even allowing to create connector.

     

    3) I also tried with creating collection in POSTMAN and then importing in Power Automate.

    However, in POSTMAN it has created with version V2/ V2.1 but in power automate it requires  V1 format.

     

    Error : The imported Postman Collection file does not have any requests, or is not in the Postman Collection V1 format.

     

    Can you please help with providing your suggestion on this?

  • Gopala_Krishna Profile Picture
    Gopala_Krishna 1,459 on at
    Re: Cloud gateway for MySQL in Power Automate

    @DivyaniR 

    Building a custom connector is relatively easy in Power Automate, the approach that I suggest is to build all the api calls and the required elements in PostMan then you can directly create a custom connector in Power Automate by importing the post man collection.

     

    GitHub - woocommerce/woocommerce: An open source eCommerce plugin for WordPress. - Link to Woocommerce API

     

    Create a custom connector from a Postman collection | Microsoft Docs - Creating custom connector from post man collection.

     

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

  • DivyaniR Profile Picture
    DivyaniR 6 on at
    Re: Cloud gateway for MySQL in Power Automate

    Thanks, @Gopala_Krishna.

     

    However, I need to connect woocommerce with Power Automate which is a plugin in WordPress.

     

    I have generated the Rest API key, so if MySQL connection doesn't works I can build a custom connector.

     

    Any idea on how to build a custom connector for woocommerce?

  • Gopala_Krishna Profile Picture
    Gopala_Krishna 1,459 on at
    Re: Cloud gateway for MySQL in Power Automate

    @DivyaniR 

    As per the connector documentation it is mentioned that the support is available only for the on-prem gateway and not the cloud ones. 

    MySQL - Connectors | Microsoft Docs

     

    There is a connector available for WordPress, that gives options to perform different actions such as fetch published content, retrieve details regarding the visitors and also see site statistics.

    WordPress - Connectors | Microsoft Docs

     

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics