(Visual FoxPro) Demonstrates how to Handle Large Integers in JSON

See more JSON Examples

Demonstrates how to handle large integers in JSON. (Integers larger than what can fit in a 32-bit signed integer.)

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loJson
LOCAL lnSuccess
LOCAL lnId
LOCAL lcAccountId

* Let's say your JSON has this:

* {
* 	"id": 20000000001234567
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')

lnSuccess = loJson.LoadFile("qa_data/json/large_int.json")
IF (lnSuccess = 0) THEN
    ? loJson.LastErrorText
    RELEASE loJson
    CANCEL
ENDIF

* The integer is too large for a 32-bit signed integer that is returned by IntOf.
* The result will be something that wrapped around and could be negative.
* In this case it would be: -543893881
lnId = loJson.IntOf("id")
? "id: " + STR(lnId)

* The solution is to read the integer value as a string, and then use the features in your programming language
* to convert from a string to a 64-bit integer.
* 
* Alternatively, you may wish to simply hold the value as a string.  If, for example, the integer simply references
* an order ID, an account ID, etc., then there's no need to convert to an integer value.  You're not going to be doing
* mathematical operations on it anyway.  This is usually the case for large integers -- they typically exist
* in JSON as an account ID.

* You can get any JSON value as a string:
lcAccountId = loJson.StringOf("id")
? "accountId: " + lcAccountId

* Sample output:

* id: -543893881
* accountId: 20000000001234567

RELEASE loJson