Hi,
I have a PowerApp which calls a third party API and inserts to a table in the dataverse. This API returns a JSON file. I was able to create the flow to parse the JSON and then add to the row:
When I run the flow, I receive the following error message:
Input parameter 'item/cr41d_companyid' is required to be of type 'Integer/int32'. The runtime value '72000987248' to be converted doesn't have the expected format 'Integer/int32'.
Inside the Parse JSON action, the company ID is an 11 digit number. Below is the input with a red arrow pointing to the company ID:
The company ID in the JSON schema is:
"company_id": {
"type": [
"integer",
"null"
]
},
The company ID field in the dataverse is of type Number:
I suspect this is because the number is 11 digits long, it's too big to be an integer (either on the JSON or dataverse level). I was wondering how do I convert this number to either a bigint or a string? For the latter, I can change the field type in the dataverse to string if needed.
Jason
