Skip to main content

Notifications

Power Automate - Connector Development
Unanswered

Connector Action Works with Direct Connection, Fails with Connection Reference

Like (0) ShareShare
ReportReport
Posted on 2 Oct 2024 15:11:09 by 8
Hi all, 
 
I find working with flows and solutions a bit confusing at times so I'll do my best to explain my issue and sound like I know what I'm doing. I'm pretty new to this and overall the experience has been good but I'm pretty shocked (and frustrated at times) that things that work awesome one minute are failing miserably the next, or that two different flows using the same connection and performing the same action don't both work. I'm the only one at my company that is using the flows/solutions I have built and am testing. They are unmanaged. I'm just building things to see how it works. I started exploring solutions as a way to organize the flows that relate to some of the processes I'm trying to automate and to use concepts like child flows.
 
1. I have a custom connector that integrates with a REST API from a 3rd party platform.
2. As I've been building flows using this connector, issues have come up due to inconsistencies in how data comes back for the same action/endpoint (example, if no value is available for a property it's a string, but when there is a value it's integer and schema validation fails). Let's just say I've had to get creative on getting this to work, and it's led to me having to edit the custom connector definition and update the connector a lot.
3. I have flows that I created in My Flows that I have added to a solution (from outside Dataverse) as well as flows that I created directly from within a solution.
 
The issue I am having is that I have one action in particular where there is a field (total_count) that is an integer in the JSON. There are many actions that follow the same pattern, and they all are defined in the connector response as Integer32. One action had the response defined as a string and I started to see an error when I tested that action. I went to the custom connector, edited, make it integer and updated the connector. 
 
1. I created a new flow and the change worked and the action ran fine.
2. I went to a solution where a flow within that solution uses a connection reference to the connector that worked in step 1, and tested. I still get the error that the total_count is a string and needs to be an integer, so the parsing of the schema is still failing in solution based flows.
 
I've tried everything I can think of and researched to get the connection reference to point to the updated version of the custom connector and nothing is working. I really don't want to have to start over completely so hoping someone can help though I wouldn't wish these types of issues on my worst enemy. This sucks.
 
This is the error I get and some of the connection details to show that when I look at the connection for the action in the flows. They are both very simple manual flows with a trigger and this 1 action from my custom connector.
 
TEST - Verify Cerbo Actions
Ran at 10/2/2024 8:53:40 AM
 
The API 'cerbo-20-2d-20by-20hand-5f0ea4a28373b4cd91-5f2efccfaa8c559174' returned an invalid response for workflow operation 'Get_questionnaires_submitted_by_patient' of type 'OpenApiConnection'. Error details: 'The API operation 'GetPatientQuestionnaires' requires the property 'body/total_count' to be of type 'Integer' but is of type 'String'.'
Connection details
Logical name
cr49f_CerboProductionv10
Created
November 3, 2023 at 9:02 AM
 
Button -> Get questionnaires submitted by patient
"connectionReferenceName": "shared_cerbo-20-2d-20by-20hand-5f0ea4a28373b4cd91-5f2efccfaa8c559174

 Connection details

Name
641339a0780c497782281fec8acb1ff2
Created
November 3, 2023 at 9:02 AM
 
The category really doesn't have to do with authentication but I had to choose something.
 
Thanks!
 
Categories:

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,316

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics

Loading started
Loading complete