JSON Parser Procedure<\/title>\n <style>\n body {\n background-color: #ffffff;\n color: #000000;\n font-family: 'Courier New', Courier, monospace;\n padding: 20px;\n }\n .code-editor {\n background: #f5f5f5;\n border: 1px solid #ccc;\n border-radius: 6px;\n padding: 20px;\n overflow-x: auto;\n white-space: pre-wrap;\n }\n .comment { color: #008000; }\n .keyword { color: #0000ff; }\n .function { color: #795e26; }\n .string { color: #a31515; }\n .variable { color: #267f99; }\n <\/style>\n<\/head>\n<body>\n\n<div class=\"code-editor\">\n<code>\n# Procedure to parse a JSON object<\/span>\nLocal<\/span> Clbfile<\/span> SRCJSON<\/span>\nSRCJSON<\/span> = '{\"msg\":\"Hello World!\"}'<\/span>\n\n# Create the object<\/span>\nLocal<\/span> Instance<\/span> OBJ<\/span> Using<\/span> OBJECT<\/span>\n\n# Parse the object<\/span>\nParseInstance<\/span> OBJ<\/span> With<\/span> SRCJSON<\/span>\n\n# Free memory<\/span>\nFreeGroup<\/span> OBJ<\/span>\n<\/code>\n<\/div>\n\n<\/body>\n<\/html>\n\n\n\nThis code parses a simple JSON string {“msg”:”Hello World!”} into the OBJ instance for further processing.<\/p>\n\n\n\n2.Contains$<\/strong> The Contains$ function checks if a parsed JSON object contains a specific property, returning 1 if the property exists and 0 if it does not.<\/p>\n\n\n\nSyntax:<\/strong> RETURN_VALUE = JSON_OBJECT.Contains$(JSON_POINTER)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RETURN_VALUE: Integer (1 for exists, 0 for does not exist).<\/li>\n\n\n\n<li>JSON_OBJECT: The parsed JSON object.<\/li>\n\n\n\n<li>JSON_POINTER: The JSON pointer expression to check (use square brackets for array indices).<\/li>\n<\/ul>\n\n\n\nExample:<\/strong><\/p>\n\n\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Check JSON Properties<\/title>\n <style>\n body {\n background-color: #ffffff;\n color: #000000;\n font-family: 'Courier New', Courier, monospace;\n padding: 20px;\n }\n .code-editor {\n background: #f5f5f5;\n border: 1px solid #ccc;\n border-radius: 6px;\n padding: 20px;\n overflow-x: auto;\n white-space: pre-wrap;\n }\n .comment { color: #008000; }\n .keyword { color: #0000ff; }\n .function { color: #795e26; }\n .string { color: #a31515; }\n .number { color: #098658; }\n .variable { color: #267f99; }\n <\/style>\n<\/head>\n<body>\n\n<div class=\"code-editor\">\n<code>\n# Procedure to check properties<\/span>\nLocal<\/span> Clbfile<\/span> SRCJSON<\/span>\nSRCJSON<\/span> = '{\"msg\":\"Hello World!\", \"list\" : [\"one\", \"two\", \"three\"]}'<\/span>\n\n# Create the object<\/span>\nLocal<\/span> Instance<\/span> OBJ<\/span> Using<\/span> OBJECT<\/span>\n\n# Parse the object<\/span>\nParseInstance<\/span> OBJ<\/span> With<\/span> SRCJSON<\/span>\n\n# Check if the JSON contains a property<\/span>\nLocal<\/span> Integer<\/span> R<\/span>\nR<\/span> = OBJ<\/span>.Contains$(\"\/msg\")<\/span> # Returns 1<\/span>\n\n# Check array element<\/span>\nR<\/span> = OBJ<\/span>.Contains$(\"\/list[1]\")<\/span> # Returns 1<\/span>\n\n# Free memory<\/span>\nFreeGroup<\/span> OBJ<\/span>\n<\/code>\n<\/div>\n\n<\/body>\n<\/html>\n\n\n\nThis example checks for the msg property and the second element in the list array.<\/p>\n\n\n\n3.Select$<\/strong> The Select$ function retrieves the value of a specific property from a parsed JSON object.<\/p>\n\n\n\nSyntax:<\/strong> RETURN_VALUE = JSON_OBJECT.Select$(JSON_PATH)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RETURN_VALUE: String containing the selected property\u2019s value.<\/li>\n\n\n\n<li>JSON_OBJECT: The parsed JSON object.<\/li>\n\n\n\n<li>JSON_PATH: The JSON path expression to select (use square brackets for array indices).<\/li>\n<\/ul>\n\n\n\nExample:<\/strong> Procedure to select properties<\/p>\n\n\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Select JSON Properties<\/title>\n <style>\n body {\n background-color: #ffffff;\n color: #000000;\n font-family: 'Courier New', Courier, monospace;\n padding: 20px;\n }\n .code-editor {\n background: #f5f5f5;\n border: 1px solid #ccc;\n border-radius: 6px;\n padding: 20px;\n overflow-x: auto;\n white-space: pre-wrap;\n }\n .comment { color: #008000; }\n .keyword { color: #0000ff; }\n .function { color: #795e26; }\n .string { color: #a31515; }\n .number { color: #098658; }\n .variable { color: #267f99; }\n <\/style>\n<\/head>\n<body>\n\n<div class=\"code-editor\">\n<code>\n# Procedure to select properties<\/span>\nLocal<\/span> Clbfile<\/span> SRCJSON<\/span>\nSRCJSON<\/span> = '{\"msg\":\"Hello World!\", \"list\" : [\"one\", \"two\", \"three\"]}'<\/span>\n\n# Create the object<\/span>\nLocal<\/span> Instance<\/span> OBJ<\/span> Using<\/span> OBJECT<\/span>\n\n# Parse the object<\/span>\nParseInstance<\/span> OBJ<\/span> With<\/span> SRCJSON<\/span>\n\n# Select a property<\/span>\nLocal<\/span> Char<\/span> MYSTR<\/span>(30)\nMYSTR<\/span> = OBJ<\/span>.Select$(\"$.msg\")<\/span> # Returns \"Hello World!\"<\/span>\n\n# Select array element<\/span>\nMYSTR<\/span> = OBJ<\/span>.Select$(\"$.list[1]\")<\/span> # Returns \"two\"<\/span>\n\n# Free memory<\/span>\nFreeGroup<\/span> OBJ<\/span>\n<\/code>\n<\/div>\n\n<\/body>\n<\/html>\n\n\n\nThis code extracts the msg property and the second element of the list array.<\/p>\n\n\n\nBest Practices for JSON Parsing<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To handle JSON data efficiently, especially when dealing with arrays or dynamic data, follow these best practices:<\/li>\n\n\n\n<li>Use Clbfile for JSON Strings: Store JSON strings in Clbfile variables to handle large or complex JSON data effectively.<\/li>\n\n\n\n<li>Always Free Memory: Use FreeGroup to release memory allocated to the JSON object and prevent memory leaks.<\/li>\n\n\n\n<li>Iterate Arrays with Loops: For JSON arrays, use a WHILE loop with Contains$ to dynamically check and extract elements.<\/li>\n<\/ul>\n\n\n\nExample (Iterating an Array):<\/strong><\/p>\n\n\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n <meta charset=\"UTF-8\">\n <title>Code Viewer<\/title>\n <style>\n body {\n background-color: #ffffff; \/* White background *\/\n color: #000000; \/* Default dark text *\/\n font-family: 'Courier New', Courier, monospace;\n padding: 20px;\n }\n .code-editor {\n background: #f5f5f5; \/* Light gray for code block *\/\n border: 1px solid #ccc;\n border-radius: 6px;\n padding: 20px;\n overflow-x: auto;\n white-space: pre-wrap;\n }\n .comment { color: #008000; } \/* Green *\/\n .keyword { color: #0000ff; } \/* Blue *\/\n .string { color: #a31515; } \/* Dark red *\/\n .function { color: #795e26; } \/* Brownish *\/\n .number { color: #098658; } \/* Greenish *\/\n .variable { color: #267f99; } \/* Blue-green *\/\n <\/style>\n<\/head>\n<body>\n\n<div class=\"code-editor\">\n<code>\n# Sample JSON<\/span>\nLocal<\/span> Clbfile<\/span> SRCJSON<\/span>\nSRCJSON<\/span> = '{\"msg\":\"Hello World!\", \"list\" : [\"one\", \"two\", \"three\"]}'<\/span>\n\n# Create the object<\/span>\nLocal<\/span> Instance<\/span> OBJ<\/span> Using<\/span> OBJECT<\/span>\n\n# Parse the object<\/span>\nParseInstance<\/span> OBJ<\/span> With<\/span> SRCJSON<\/span>\n\n# Array to store results<\/span>\nLocal<\/span> Char<\/span> MYSTR<\/span>(30)(0..)\nLocal<\/span> Integer<\/span> I<\/span> : I<\/span> = 0<\/span>\n\n# Iterate over list array<\/span>\nWHILE<\/span> I<\/span> >= 0<\/span>\n # Check if the property exists<\/span>\n If<\/span> OBJ<\/span>.Contains$(\"\/list\/\"<\/span> + NUM$(I<\/span>)) = 1<\/span>\n MYSTR<\/span>(I<\/span>) = OBJ<\/span>.Select$(\"$.list[\"<\/span> + NUM$(I<\/span>) + \"]\"<\/span>)\n I<\/span> += 1<\/span>\n Else<\/span>\n BREAK\n Endif<\/span>\nWEND<\/span>\n\n# Free memory<\/span>\nFreeGroup<\/span> OBJ<\/span>\n<\/code>\n<\/div>\n\n<\/body>\n<\/html>\n\n\n\nThis script iterates through the list array, extracting each element until no more elements are found.<\/p>\n\n\n\nConclusion<\/strong> Sage X3\u2019s JSON parsing 4GL functions (ParseInstance, Contains$, and Select$) provide a robust way to handle JSON data within your scripts. By following the syntax and best practices outlined above, you can efficiently parse, query, and extract data from JSON strings. Always ensure proper memory management with FreeGroup and use loops for dynamic array processing to make your code scalable and maintainable.<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"Since the 2023R2 release, Sage X3 has introduced JSON parsing 4GL functions, enabling developers to efficiently fetch and process data from JSON-formatted strings. This blog explores the key JSON parsing functions\u2014ParseInstance, Contains$, and Select$\u2014and provides practical examples and best practices for their use. Introduction to JSON Parsing in Sage X3 JSON (JavaScript Object Notation) is\u2026 <a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/06\/30\/how-to-read-json-using-json-parsing-4gl-functions-in-sage-x3\/\">Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[4391,4386,4389,4387,4385,4388,4384,4390],"class_list":["post-30964","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-best-practices-for-json-parsing-in-sage-x3","tag-contains-in-sagex3","tag-json-functionality-in-sage-x3","tag-json-in-sage-x3","tag-json-parsing","tag-parseinstance-object-in-sage-x3","tag-read-json-in-sage-x3","tag-select-in-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=30964"}],"version-history":[{"count":14,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30964\/revisions"}],"predecessor-version":[{"id":31013,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30964\/revisions\/31013"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":30964,"date":"2025-06-30T08:38:07","date_gmt":"2025-06-30T08:38:07","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=30964"},"modified":"2025-06-30T11:46:46","modified_gmt":"2025-06-30T11:46:46","slug":"how-to-read-json-using-json-parsing-4gl-functions-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/06\/30\/how-to-read-json-using-json-parsing-4gl-functions-in-sage-x3\/","title":{"rendered":"How to Read JSON Using JSON Parsing 4GL Functions in Sage X3"},"content":{"rendered":"\n

Since the 2023R2 release, Sage<\/a> <\/a>X3<\/a> has introduced JSON parsing 4GL functions, enabling developers to efficiently fetch and process data from JSON-formatted strings. This blog explores the key JSON parsing functions\u2014ParseInstance, Contains$, and Select$\u2014and provides practical examples and best practices for their use.<\/p>\n\n\n\n

Introduction to JSON Parsing in Sage X3<\/strong><\/p>\n\n\n\n

JSON (JavaScript Object Notation) is a lightweight data-interchange format widely used for structured data. With Sage X3’s JSON parsing functions, you can parse JSON strings, check for specific properties, and extract values seamlessly within 4GL scripts. These functions are particularly useful for integrating external data or processing structured inputs.<\/p>\n\n\n\n

New Stuff :-<\/strong> Implementing User-Specific Access Control in Sage X3 for the Receipt Line Inquiry Screen<\/a><\/p>\n\n\n\n

Key JSON Parsing Functions<\/strong><\/p>\n\n\n\n

1.ParseInstance<\/strong>
The ParseInstance function is used to parse a JSON string into an object that can be queried or manipulated.<\/p>\n\n\n\n

Syntax<\/strong>:
ParseInstance OBJECT With JSON_OBJECT<\/p>\n\n\n\n