Posts: 761
Threads: 260
Joined: Jul 2012
Can QM interact/modify a JSON file?
Assuming I have the following json file:
File: c:\test.json
{
"version": 4,
"lastUserContextId": 1,
"identities": [{
"userContextId": 1,
"public": false,
"icon": "txt",
"color": "",
"name": "test 1",
"accessKey": ""
}, {
"userContextId": 2,
"public": false,
"icon": "txt",
"color": "",
"name": "test 2",
"accessKey": ""
}, {
"userContextId": 3,
"public": false,
"icon": "txt",
"color": "blue",
"name": "test 3"
}
]
}
Is it possible with QM to remove, add and modify and object?
I have the questions below in the code with the desired result
1. Remove whole json object 'userContextId": 3'
RESULT:
{
"version": 4,
"lastUserContextId": 1,
"identities": [{
"userContextId": 1,
"public": false,
"icon": "txt",
"color": "",
"name": "test 1",
"accessKey": ""
}, {
"userContextId": 2,
"public": false,
"icon": "txt",
"color": "",
"name": "test 2",
"accessKey": ""
}
]
}
2. Add object
"userContextId": 7,
"public": true,
"icon": "doc",
"color": "red",
"name": "test 7",
"accessKey": "123"
RESULT:
{
"version": 4,
"lastUserContextId": 1,
"identities": [{
"userContextId": 1,
"public": false,
"icon": "txt",
"color": "",
"name": "test 1",
"accessKey": ""
}, {
"userContextId": 2,
"public": false,
"icon": "txt",
"color": "",
"name": "test 2",
"accessKey": ""
}, {
"userContextId": 7,
"public": true,
"icon": "doc",
"color": "red",
"name": "test 7"
"accessKey": "123"
}
]
}
3. Modify key-value pair, of "userContextId": 1," ---> modify name from 'test 1' tot 'test 1B'
RESULT:
{
"version": 4,
"lastUserContextId": 1,
"identities": [{
"userContextId": 1,
"public": false,
"icon": "txt",
"color": "",
"name": "test B", <===============
.....
[/code]
Posts: 11,900
Threads: 138
Joined: Dec 2002
06-15-2021, 07:25 PM
(This post was last modified: 06-15-2021, 07:27 PM by Gintaras.)
Need some JSON library. Many libraries exist for many languages, but difficult to find something that can be easy enough to use in QM. It is one of reasons why QM3 will use C# and .NET.
Posts: 761
Threads: 260
Joined: Jul 2012
Ok! thank you for the info!
I'll use string actions until then!
Posts: 1,333
Threads: 61
Joined: Jul 2006
06-16-2021, 09:23 PM
(This post was last modified: 06-16-2021, 09:27 PM by Kevin.)
Ron you can use Chilkat with qm to process json data. there is an activex com component or a .net version. The .net version is a bit easier but requires you to use CsScript.
here is all your request using the ChilkatDotNet47.dll .Just place it in qm program folder
here is the zip file containing the dll.
chilkatdotnet47-9.5.0-win32.zip (Size: 3.2 MB / Downloads: 191)
Function ChilkatJsonExamples
out
str json=
;{
;;;;"version": 4,
;;;;"lastUserContextId": 1,
;;;;"identities": [{
;;;;;;;;;;;;"userContextId": 1,
;;;;;;;;;;;;"public": false,
;;;;;;;;;;;;"icon": "txt",
;;;;;;;;;;;;"color": "",
;;;;;;;;;;;;"name": "test 1",
;;;;;;;;;;;;"accessKey": ""
;;;;;;;;}, {
;;;;;;;;;;;;"userContextId": 2,
;;;;;;;;;;;;"public": false,
;;;;;;;;;;;;"icon": "txt",
;;;;;;;;;;;;"color": "",
;;;;;;;;;;;;"name": "test 2",
;;;;;;;;;;;;"accessKey": ""
;;;;;;;;}, {
;;;;;;;;;;;;"userContextId": 3,
;;;;;;;;;;;;"public": false,
;;;;;;;;;;;;"icon": "txt",
;;;;;;;;;;;;"color": "blue",
;;;;;;;;;;;;"name": "test 3"
;;;;;;;;}
;;;;]
;}
CsScript x
x.SetOptions("references=C:\Program Files (x86)\Quick Macros 2\ChilkatDotNet47.dll")
x.AddCode("")
;call static function
str R=x.Call("Class1.TestFunction" json)
out R
#ret
//C# code
using System;
using Chilkat;
public class Class1
{
,public static string TestFunction(string s)
,{
,,Chilkat.JsonObject json = new Chilkat.JsonObject();
,,bool success = json.Load(s);
,,Chilkat.JsonArray tagsArray = json.ArrayOf("identities");
,,Console.WriteLine("Remove whole json object userContextId': 3 and output result");
,,tagsArray.DeleteAt(2);
,,json.EmitCompact = false;
,,Console.WriteLine(json.Emit());
,,Console.WriteLine("Add object and output result");
,,json.UpdateString("identities[2].userContextId","7");
,,json.UpdateBool("identities[2].public",true);
,,json.UpdateString("identities[2].icon","doc");
,,json.UpdateString("identities[2].color","red");
,,json.UpdateString("identities[2].name","test 7");
,,json.UpdateString("identities[2].accessKey","123");
,,json.EmitCompact = false;
,,Console.WriteLine(json.Emit());
,,Console.WriteLine("Modify key-value pair, of ''userContextId'': 1,'' ---> modify name from ''test 1'' to ''test 1B''");
,,json.UpdateString("identities[0].name","test 1B");
,,json.EmitCompact = false;
,,Console.WriteLine(json.Emit());
,,return "finished";
,}
}
Posts: 1,333
Threads: 61
Joined: Jul 2006
06-16-2021, 11:12 PM
(This post was last modified: 06-16-2021, 11:36 PM by Kevin.)
this is the activeX version of chilkat in qm
goto Download the Chilkat ActiveX
install 32bit version i believe
Function ChilkatActivexExamples
out
typelib Chilkat_v9_5_0 {004CB902-F437-4D01-BD85-9E18836DA5C2} 1.0
Chilkat_v9_5_0.ChilkatJsonArray ja._create
Chilkat_v9_5_0.ChilkatJsonObject jo._create
Chilkat_v9_5_0.ChilkatJsonObject json._create
str filename.expandpath("$desktop$\test.json")
jo.LoadFile(filename)
jo.EmitCompact=0
out "original json with formatting"
out jo.Emit
out "Remove whole json object userContextId': 3 and output result"
ja= jo.ArrayOf("identities")
ja.DeleteAt(2)
out jo.Emit
out "Add object and output result"
ja.AddObjectAt(2)
json=jo.ArrayOf("identities").ObjectAt(2)
json.SetStringOf("userContextId","7")
json.SetBoolOf("public",1)
json.SetStringOf("icon","doc");
json.SetStringOf("color","red");
json.SetStringOf("name","test 7");
json.SetStringOf("accessKey","123");
out jo.Emit
json=jo.ArrayOf("identities").ObjectAt(0)
out "Modify key-value pair, of ''userContextId'': 1,'' ---> modify name from ''test 1'' to ''test 1B''"
json.UpdateString("name","test 1B");
out jo.Emit
jo.WriteFile(filename)
out "finished"
Posts: 761
Threads: 260
Joined: Jul 2012
@Kevin, Thanks! Going to try this!
Posts: 1,006
Threads: 330
Joined: Mar 2007
|
