Summary
How it works
Crystal Reports
Date
COPY_ARRAY
IS_WEEKEND
Decimal
COPY_ARRAY
Development
LINK_OPEN
VALIDATE
VALIDATE_TRANSACTION
VIEW_SCREEN
Integer
COPY_ARRAY
Short Integer
COPY_ARRAY
File
CREATE_DIRECTORY
CSV_TO_XLSX
DEL_DIRECTORY
DOWNLOAD
GET_COMPLETE_NAME
GET_EXTENSION
GET_HASH
GET_NAME
LIST_DIRECTORIES
LIST_FILES
PATH_TO_VOLUME
UNZIP
UPLOAD
VOLUME_TO_PATH
ZIP
FTP
DELETE
DOWNLOAD
LIST
UPLOAD
Image
GENERATE_CODE
IMAP
LIST_DIRECTORIES
Json
COUNT
DEL_KEY
GET_KEYS
GET_ONE
GET_POS_KEY
GET_TYPE
GET_VALUE
SET_VALUE
TO_ARRAY
MongoDB
QUERY
SMS
SEND
SMTP
SEND_EMAIL
Stock
GET_AVAILABLE_QTY
GET_COST
Text
COPY_ARRAY
COUNT_OCCURRENCES
HTML_DECODE
HTML_ENCODE
HTML_TO_TXT
IS_NUMERIC
LINK_DECODE
LINK_ENCODE
RANDOM
REPLACE
RTF_TO_TXT
SPLIT
TO_BASE64
User
CHECK_PASSWORD
Sale
CLOSE_ORDER
GET_PRICE
VALIDATE_DELIVERY
func X3.EN_JSON_SET_VALUE(Clbfile JSON_OUT, Char KEY_IN, Char TYPE_IN, Clbfile VALUE_IN) : Tinyint
Add or modify a key and a value to a Json
- JSON_OUT Clbfile : Original Json and returned modified
- KEY_IN Char : Key to insert / update
- TYPE_IN Char : Type of data to insert:
- b : boolean (true, false)
- a : alphanumeric (SageX3, L.V. expertise X3)
- n : numeric (10, 1.23)
- d : date (YYYY-MM-DDThh:mm:ssZ)
- c : collection ([{},{}])
- t : array (["",""])
- j : json ({...})
- o : BinData
- i : ObjectId
- u : NumberInt
- z : not determined (not found or null)
- VALUE_IN Clbfile : The value to insert in one of the following formats:
- Strings : string > "string"
- Dates : 2021-01-16T21:42:42.132Z : "ISODate("2021-01-16T21:42:42.132Z")"
- Numerics : 2.30 > 2.30
- Booleans : true > true
- Collections : [{},{}] > [{},{}]
- Json : {} > {}
- Null : null > null
- ObjectId : 123456789 > ObjectId("123456789")
Example
# Adding an Alphanumeric "test" key with the value "my value" in a Json flow contained in the Clob [L]JSON
Local Clbfile JSON(8)
If func X3.EN_JSON_SET_VALUE([L]JSON, "test", "a", "my value")
Infbox "Added"
Else
Infbox "Error : " + GX3ERR
Endif