how to check presence of value in json

[MrSpark]

I have been striving to find an solution that how to check if JSON has specific string "Processing":true if it has then copy the "newLogno":776655 the ID.

Here is entire JSON

{"id":16,"sku":"4926","productName":"Diforda","upc":"test",
"condition":"test","uniqueID":1234,"logsCey":3,
"Processing":true,"addedDateTime":"2021-06-22T04:07:35.15",
"softDelete":false,"newLogno":776655}

If someone can please share a solution i would really appreciate.

 

[RayFrye]

GitHub - VBA-tools/VBA-JSON: JSON conversion and parsing for VBA

JSON conversion and parsing for VBA. Contribute to VBA-tools/VBA-JSON development by creating an account on GitHub.

github.com

 

[Marc L]

​

As JSon is nothing else than text so you can use some VBA basics text functions like for example Instr, Split, … at beginner level.​

 

[MrSpark]

sorry for being late but thank you very much i achieved this.