web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / JSON parsing error, ex...
Power Apps
Unanswered

JSON parsing error, expected 'number' but got 'string

(1) ShareShare
ReportReport
Posted on by 8
REPOST: I saw that someone replied to my post earlier today, but post does not appear to exist.  

In powerapp ClearCollect: I don't understand the reason for this ERROR,  thoughts appreciated...


ERROR:
"data": {
    "errorMessage": "JSON parsing error, expected 'number' but got 'string'.",
    "raiseToastNotification": false,
    "wasReported": false,
    "functionName": null,
    "context": {
      "entityName": "",
      "id": -1,
      "propertyName": "Equipment"
    },
    "info": "JSON parsing error, expected 'number' but got 'string'."
  }

DOCUMENT:
{
        "__metadata": {
          "id": "https://myurl/sap/opu/odata/sap/API_EQUIPMENT/Equipment(Equipment='999999',ValidityEndDate=datetime'2006-07-26T00%3A00%3A00')",
          "uri": "https://myurl/sap/opu/odata/sap/API_EQUIPMENT/Equipment(Equipment='999999',ValidityEndDate=datetime'2006-07-26T00%3A00%3A00')",
          "type": "equipment.EquipmentType"
        },
        "Equipment": 999999,
        "EquipmentName": "Trailer"
      }

SWAGGER DEFINITION:
Plain Text
definitions:
  MYSTUFF:
    type: object
    properties:
      __metadata:
        type: object
      Equipment:
        type: number
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,335 Super User 2025 Season 2 on at
    Hi,
     
    The error is actually pretty clear (fortunately). 
     
    You a have a column that in your definition, says it a Number, but you are passing it a String.
     
    According to this 
    Equipment
    is supposed to be a Number, but you are passing a string.
     
     
  • nocturnalcodeha Profile Picture
    8 on at
    Sorry I was not clear DOCUMENT above is in the complete content of “body”: { }.  Equipment is an unquoted string in the response body, making it a number. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard