@JSONREMOVE[xpath] : Removes the element or value set in XPath. The file must have been opened with a previous @JSONOPEN.
If xpath is not specified, @JSONREMOVE will use the current XPath.
Returns 0 on success, or a JSON error code on failure.
Example:
With this JSON file:
{
"store": {
"books": [
{
"category": "reference",
"author": "Nigel Rees",
"title": "Sayings of the Century",
},
{
"category": "fiction",
"author": "Evelyn Waugh",
"title": "Sword of Honour",
}
]
}
}
To remove the "category" properties from each book:
%@jsonremove[/json/store/books/[1]/category]
%@jsonremove[/json/store/books/[2]/category]
To remove the first book:
%@jsonremove[/json/store/books/[1]]
JSON Errors
10231 Unbalanced element tag |
10232 Invalid JSON markup |
10233 Invalid XPath |
10234 DOM tree unavailable |
XMLp Errors
101 Invalid attribute index |
102 No attributes available |
103 Invalid namespace index |
104 No namespaces available |
105 Invalid element index |
106 No elements available |
107 Attribute does not exist |
201 Unbalanced element tag |
202 Unknown element prefix (can't find namespace) |
203 Unknown attribute prefix (can't find namespace) |
204 Invalid XML markup |
205 Invalid end state for parser |
206 Document contains unbalanced element |
207 Invalid XPath |
208 No such child |
209 Top element does not match start of path |
210 DOM tree unavailable |
302 Can't open file. |
