Power Automate - Custom Connector - NULL values are being dropped in the flow from the schema

(0) Share

Report

Posted on by DragonLord

200

Hi,

I have a custom connector that retrieves data from an API.

The API correctly returns all the required fields.

When i call this custom connector using Flow, the data is returned, HOWEVER, if one of the values contains a NULL it does not appear in the schema, which causes the flow to break further down.

Example:

Source from the custom connector:

"UserId": "24XILTQNtfUu4VwsfLZN3A2",

"Title": "Test Course",

"CourseId": "G8ZeXsFgng41",

"Score": "",

"Result": "Complete",

"Type": "Course Completed",

"AchievementId": 64881430,

"CertificateId": null

}

what is returned from the custom connector using Flow :

"UserId": "24XILTQNtfUu4VwsfLZN3A2",

"Title": "Test Course",

"CourseId": "G8ZeXsFgng41",

"Score": "",

"Result": "Complete",

"Type": "Course Completed",

"AchievementId": 64881430

}

As you can see , the "CertificateId" from the JSON is missing.

Is it normal behavior for flow to drop any json tags with null from a custom connector?

If so, how can i get around this??

swagger definition below:

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

MJain 2,450 on at

Like (0)

Report

Hi @DragonLord ,

After the response is received from custom connector use Parse JSON and use the one which has all fields. Add null in the schema as follows:
["string","null"] to handle null values.

Thanks

Was this reply helpful? Yes No
DragonLord 200 on at

Like (0)

Report

does not work unfortunately, the JSON tags are being removed by the custom connector, so even using PARSE JSON does not recognise them.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

Hi @DragonLord ,

Use Parse Json action with the content you have provided as you mentioned the custom connector is not sending certificate :
{
"UserId": "24XILTQNtfUu4VwsfLZN3A2",
    "Title": "Test Course",
    "CourseId": "G8ZeXsFgng41",
    "Score": "",
    "Result": "Complete",
    "Type": "Course Completed",
    "AchievementId": 64881430,
    "CertificateId": null
}

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have been using your mention code and want to implement it on my site of https://canoesurfer.net/ but it was not working and I was really worried about that and could not found anyway that how can i solve this.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

@Anonymous ,
Can you please share your flow screenshots ?

Thanks

Was this reply helpful? Yes No
Verified answer

DragonLord 200 on at

Like (0)

Report

i managed to get around this by testing if the "missing" JSON tag had a length of > 0.
its a crap solution but it seems to work for now 😞

Was this reply helpful? Yes No