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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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,963 Moderator 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

#2
11manish Profile Picture

11manish 193

#3
Valantis Profile Picture

Valantis 138

Last 30 days Overall leaderboard