Grades and IDs coming through as floating points instead of String Values.

[svcDataflows]

Hi all, 

I've been tasked with pulling data using Canvas' REST API using a custom connector developed for a Power Apps Environment.

One of the getter methods I'm using is retrieving Student Enrolments by Section and including their grades. However, when I'm using this method, I'm receiving errors stating that the response expects a String but is receiving a float. I've tested this directly into the URI, as well as in Postman using GraphQL. In all three situations I'm receiving float values. 

Is this an intended change or a defect? 

Thanks for all your help,

Dave


REST METHOD: GET /api/v1/sections/:section_id/enrollments

[sendres]

Hi @svcDataflows,

This Canvas API endpoint returns grade values as floats, full stop. To my knowledge, it's always worked this way and therefore is neither an "intended change" nor a "defect"; it's just the expected behavior from the Canvas API.

I can't speak to how your Power Apps custom connector might be trying to use the Canvas data, but it seems confusing to me that it would expect numerical values to come in as strings. To my knowledge, the Power Platform currently only supports the float type for numerical data. If your custom connector is expecting strings, it's most likely internally converting them to floats in order to perform further calculations on them.

f this were my project, my first instinct would be to tear into your custom connector to see if it can me modified to accept the floats from the Canvas API as input.

Steven