JSON.Replace

Searches for all values that match the JSONPath expression and replaces them with the specified value.

Parameters

Parameter	Description	Example
json	A JSON text or reference.	"{\"people\":[{\"first\":\"Christian\",\"last\":\"Schmitz\",\"city\":\"Nickenich\"}]}"
path	The path to query.	"$.books[?(@.title == 'A Wild Sheep Chase')].price"
ReplaceJSON	The new JSON value.	123

Result

Returns JSON or error.

Description

Examples

Find an entry in the books array and change the value:

Let([
json = "{
        \"books\": [
                {
                        \"author\": \"Haruki Murakami\",
                        \"category\": \"fiction\",
                        \"price\": 20.0,
                        \"title\": \"A Wild Sheep Chase\"
                },
                {
                        \"author\": \"Sergei Lukyanenko\",
                        \"category\": \"fiction\",
                        \"price\": 23.58,
                        \"title\": \"The Night Watch\"
                },
                {
                        \"author\": \"Graham Greene\",
                        \"category\": \"fiction\",
                        \"price\": 21.99,
                        \"title\": \"The Comedians\"
                },
                {
                        \"author\": \"Phillips, David Atlee\",
                        \"category\": \"memoir\",
                        \"title\": \"The Night Watch\"
                }
        ]
}";
output = MBS( "JSON.Replace"; json; "$.books[?(@.title == 'A Wild Sheep Chase')].price"; 123 )
]; output)

See also

• JSON.Query
• JSON.Release
• JSON.ReplaceItemInArray
• JSON.ReplaceItemInObject

Release notes

• Version 14.1
  • Changed JSON.Replace to accept text or number as replacement and convert it to JSON internally automatically instead of returning a parsing error.
  • Fixed an edge case with JSON.Replace where it didn't catch all spots.
• Version 13.5
  • Added JSON.Replace to replace within a JSON.

Example Databases

• JSON/JSON Query

Blog Entries

• Neues MBS Plugin 14.1 für Claris FileMaker
• MBS Plugin 14.1 for Claris FileMaker
• MBS FileMaker Plugin, version 14.1pr5
• MBS FileMaker Plugin, version 14.1pr3
• New in MBS FileMaker Plugin 13.5
• MBS Plugin 13.5 for Claris FileMaker
• Using JSONPath in FileMaker
• Checking out JSON.Search function in MBS FileMaker Plugin
• JSON Query in FileMaker
• MBS FileMaker Plugin, version 13.5pr1

This function checks for a license.

Created 17th September 2023, last changed 13th October 2023

JSON.ReleaseAll - JSON.ReplaceItemInArray