Summary
How it works
Date
COPY_ARRAY
IS_WEEKEND
Decimal
COPY_ARRAY
Development
LINK_OPEN
VALIDATE
VALIDATE_TRANSACTION
VIEW_SCREEN
Integer
COPY_ARRAY
File
CREATE_DIRECTORY
UNZIP
UPLOAD
LIST_FILES
LIST_DIRECTORIES
GET_HASH
GET_EXTENSION
GET_NAME
GET_COMPLETE_NAME
PATH_TO_VOLUME
DOWNLOAD
VOLUME_TO_PATH
ZIP
Image
GENERATE_CODE
IMAP
LIST_DIRECTORIES
JSON
COUNT
SET_VALUE
GET_KEYS
GET_TYPE
GET_POS_KEY
GET_ONE
GET_VALUE
DEL_KEY
TO_ARRAY
SMS
SEND
SMTP
SEND_EMAIL
Stock
GET_COST
GET_AVAILABLE_QTY
Text
RANDOM
COUNT_OCCURRENCES
COPY_ARRAY
SPLIT
IS_NUMERIC
HTML_DECODE
HTML_ENCODE
HTML_TO_TXT
LINK_DECODE
LINK_ENCODE
REPLACE
RTF_TO_TXT
User
CHECK_PASSWORD
Sale
GET_PRICE
CLOSE_ORDER
func X3.EN_JSON_GET_VALUE(Clbfile JSON_IN, Char KEY_IN) : Clbfile

Used to retrieve the value of a KEY_IN key, of a Json JSON_IN.

  • JSON_IN Clbfile The clob containing the Json
  • KEY_IN Alpha The key to retrieve
Return Clbfile Clob containing the value associated with the key :
  • Strings "string" > string
  • Dates "ISODate("2021-01-16T21:42:42.132Z")" > 2021-01-16T21:42:42.132Z
  • Numerics 2.30 > 2.30
  • Booleans true : true
  • Collections [{},{}] > [{},{}]
  • Json {} > {}
  • Null null > null
Example