{"id":32895,"date":"2022-10-21T11:27:46","date_gmt":"2022-10-21T05:57:46","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=32895"},"modified":"2022-12-02T17:39:05","modified_gmt":"2022-12-02T12:09:05","slug":"parsing-json-string-into-a-json-object-using-parsejson-function-in-canvas-app-within-power-platform","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/10\/parsing-json-string-into-a-json-object-using-parsejson-function-in-canvas-app-within-power-platform\/","title":{"rendered":"Parsing JSON string into a JSON object using ParseJSON() function in Canvas App within Power Platform"},"content":{"rendered":"

A few months ago we published one of our blogs<\/a> to parse the JSON string using regular expression. As per the blog, to parse the JSON string into JSON object we have to format the JSON string into regular expression format as shown below:<\/p>\n

“\\{“”id””:””(?<id>[^””]*)””,””name””:””(?<name>[^””]*)”<\/em><\/strong><\/p>\n

Now, we can directly parse JSON string using ParseJSON()<\/em><\/strong> function, so there is no need to format string into the regular expression to parse JSON.<\/p>\n

To parse JSON string using ParseJSON() <\/em><\/strong>function, you have to enable the \u201cParse JSON function and untyped object\u201d within upcoming features of the Canvas App. If you have not enabled this in the upcoming feature then ParseJSON() <\/em><\/strong>function will not work in your canvas app. To enable this feature Go to Settings> Click on the \u201cUpcoming Features\u201d tab > Search \u201cParseJSON function\u201d keyword in the search box > Enable the \u201cParse JSON function and untyped object\u201d feature as shown in the screenshot below:<\/p>\n

\"\"<\/p>\n

Please find the below syntax and example of the ParseJSON()<\/em><\/strong> function:<\/p>\n

Syntaxt:<\/strong><\/p>\n

ParseJSON(JSON_STRING)<\/em><\/strong><\/p>\n

Where,<\/p>\n

JSON_STRING \u2013 It strings in JSON format as shown below:<\/p>\n

\u201c{\u201cid\u201d:\u201d958788BD-DA0A-4859-9788-13509BC29D7B\u201d,\u201d name\u201d:\u201d Basic User\u201d}\u201d<\/p>\n

Example:<\/strong><\/p>\n

We have created a Canvas App where we want to read the security role of the user from JSON string as shown below. When the user clicks on the \u201cConvert to JSON\u201d button a power FX expression executes. It will read the JSON string that the user enters in the first text box and converts that JSON string into a JSON object and returns the value which is associated with the \u201cname\u201d key in the JSON string. Finally, it displays the output in label control which is highlighted in the screenshot below.<\/p>\n

\"\"<\/p>\n

Please find the below power FX expression which executes on click of the \u201cConvert to JSON\u201d button:<\/p>\n

Set(txtValue,Text( ParseJSON(jsonstringtb.Text).name ))<\/em><\/strong><\/p>\n

Please find the below data types in the Canvas App and their JSON string and also how we can parse those strings.<\/p>\n

1. Boolean:<\/p>\n

{\u201cflag\u201d: true}<\/p>\n

Boolean( ParseJSON(“{ “flag”: true }”).flag )<\/p>\n

2. Currency and Number<\/p>\n

{ “value”: 65.6 }<\/p>\n

Value( ParseJSON(“{ “value”: 65.6 }”).value )<\/p>\n

3. Date, DateTime, and Time<\/p>\n

{ “Date”: “10-19-2022” }<\/p>\n

DateValue( ParseJSON(“{ “date”: “2022-05-10″}”).date )<\/p>\n

Conclusion<\/strong><\/h2>\n

Using ParseJSON()<\/em><\/strong> function we can easily parse the JSON string to a JSON object and retrieve any value from a converted JSON object. <\/u><\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

A few months ago we published one of our blogs to parse the JSON string using regular expression. As per the blog, to parse the JSON string into JSON object we have to format the JSON string into regular expression format as shown below: “\\{“”id””:””(?<id>[^””]*)””,””name””:””(?<name>[^””]*)” Now, we can directly parse JSON string using ParseJSON() function,\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[18,2361],"tags":[],"class_list":["post-32895","post","type-post","status-publish","format-standard","hentry","category-dynamics-365-v9-2","category-technical"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=32895"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=32895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=32895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=32895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}