The JSON macro can parse a JSON string. It exposes properties to query the resulting object and methods to modify it.

Syntax

Smartsite SXML	Copy Code
<se:json />

Parameters

Name	Data Type	Properties	Description
Id	String	MustBeAttribute Trim	Sets the Id of the macro. Macros with Ids set can be accessed using Viper by referring to page.[id].[methodname()].
InputData	Any	-	Sets the input data (Json).
Source	String	Default	Sets the source of the JSON object.
UseXmlDates	Boolean	-	Determines how the Json object serializes dates. If true, an Xml DateTime literal is used, otherwise a JavaScript new Date constructor is used.

Shared Parameters

Name	Data Type	Properties	Description
Access	String	-	Friendly name of the minimum access type level required by the site visitor to execute this macro.
AccessDenied	String	RawData	Sets the value that is returned when the site visitor has insufficient access.
AIM	Enum	-	Sets the AIM scanning mode of the macro. Enum values: NotSet Not set. Off No AIM scanning. External Output XML scanning. Internal Internal scanning, implemented by AIM-aware macros. Autonomous Relations are to be linked to the current source item, instead of the rendered page. SoftLink Should generate soft links (in combination with External flag). InternalAutonomous Internal scanning, combined with the Autonomous setting. ExternalAutonomous External scanning, combined with the Autonomous setting. ExternalAutonomousSoftLink External scanning, combined with the Autonomous and softLink settings. ExternalSoftLink External scanning, combined with the Softlink setting.
Condition	String	MustBeAttribute ExpressionSyntax XmlDecode	Sets the Viper expression to evaluate before actually executing the macro. If the expression returns false, the execution of the module and its child modules is skipped.
Default	String	RawData	Sets the default value that will be returned when the execution would otherwise return an empty string.
Error	String	RawData	Sets the value to return in case on error occurs during execution. The Viper expressions this.error(), this.error(full) and this.error(type) are available in this context.
Id	String	MustBeAttribute Trim	Sets the Id of the macro. Macros with Ids set can be accessed using Viper by referring to page.[id].[methodname()].
LocalId	String	MustBeAttribute Trim	Sets the local id of the macro in the current buffer scope.
Rem	String	RawData NoCache Trim	Sets the remarks. Remarks have no effect on the actual execution of the module. They only improve the readability of the code.
ResultFormat	String	RawData	Sets the resultformat.
ResultType	Enum	-	Sets the type of the result. Enum values: Undefined Not set None No result String Default type Object Generic object Binary Binary data Boolean Boolean DataTable DataTable DateTime Date/time Float Floating point numeric data Integer Integer Locator Extended Uri Xml Xml Data
Save	Collection	-	Sets the buffer names.
Status	Enum	-	Gets a value indicating the ModuleStatus of this module. Enum values: Unknown Unknown BeginInitialize Initializing the module EndInitialize Module has fully initialized BeginSetProperties Properties are about to be set EndSetProperties Properties have been set BeginExecute Execution starts BeginFormatData Starting data formatting. EndFormatData Ended data formatting. BeginFormatResult Before formating result. EndFormatResult After formatting result EndExecute Execution is ending StartLoseScope Execution has completed EndLoseScope Module is about to unload Error Module is in an error state
Timeout	Float	-	Sets the timeout in seconds. In the overriden Execute() method, you can call CheckTimeout() to check whether execution has timed out.
Trim	Enum	MustBeAttribute	Gets a value indicating how the whitespace is trimmed.
Whitespace	Enum	MustBeAttribute	Gets a value indicating whether to preserve whitespace. Enum values: Inherit Inherit from parent. Preserve Keep all whitespace. Remove Remove all whitespace. Normalize Convert all whitespace to single spaces. SimpleFormat Convert all whitespace to single spaces, but keep single line breaks.

Local Viper Methods

Viper	Extension	Description
This.Add	✓	Add a named property on the JSON object. Fails if the object already contains a property by the same name.
This.AddNull	✓	Add a null property on the JSON object. Fails if the object already contains a property by the same name.
This.AddValue	✓	Add a named property on the JSON object. Fails if the object already contains a property by the same name.
This.ClearForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.
This.Exists	✓	Indicates whether the given property exists in the JSON object.
This.Get	✓	Gets the string representation of the JSON object.
This.GetByPosition	✓	Gets the string representation of the JSON object at the given position.
This.GetEncoded	✓	Gets the string representation of the JSON object and encodes ampersands for use on the client.
This.GetEncodedValue	✓	Gets the typed value of a named property from the JSON object. If the typed value is a string ampersands will be encoded for use on the client.
This.GetForcedResult		Gets the forced result of the macro, set by overriding the normal rendering using SetForcedResult().
This.GetJson	✓	Gets the json object for later use.
This.GetJsonTypeName	✓	Gets the type of the JSON object.
This.GetJsonTypeName	✓	Gets the type of a named property from the JSON object.
This.GetNameByPosition	✓	Gets the property name by position.
This.GetValue	✓	Gets the typed value of a named property from the JSON object.
This.GetValueByPosition	✓	Gets the typed property by position.
This.Length	✓	Gets the number of properties on the outer JSON object.
This.Load	✓	Loads the given string into the JSON object. Destroys the existing object.
This.MimeType	✓	Returns the MIME type for a request or response that uses JSON.
This.Remove	✓	Removes a property from the JSON object.
This.RenderTime	✓	Returns the render time of the macro in milliseconds.
This.Set	✓	Sets a named property on the JSON object.
This.SetForcedResult		Sets the result of the macro. used to override the normal handling of the result creation.
This.SetNull	✓	Sets a named property on the JSON object to Null.
This.SetValue	✓	Sets a named property on the JSON object.

Shared Local Viper Methods

Viper	Extension	Description
This.AIM.Relations	✓	Gets a list of all outgoing AIM relations created by the macro.
This.Buffer.Exists		Checks whether a local buffer exists.
This.Buffer.Get		Gets a local buffer.
This.Buffer.Set		Sets a local buffer.
This.Error.InnerException.Message		Returns the text message of the inner exception of the exception that has occurred.
This.Error.InnerException.SmartsiteCode		Returns Smartsite error code of the inner exception of the exception that has occurred.
This.Error.InnerException.Throw		Makes Smartsite throw the inner exception.
This.Error.InnerException.ToString		Returns the full information of the inner exception of the exception that has occurred, including the stack trace.
This.Error.InnerException.Type		Returns the full Type name of the inner exception of the exception that has occurred.
This.Error.Message		Returns the text message of the exception that has occurred.
This.Error.SmartsiteCode		Returns the Smartsite Error code of the exception that has occurred.
This.Error.Throw		Makes Smartsite throw the current exception.
This.Error.ToString		Returns the full information of the exception that has occurred, including the stack trace.
This.Error.Type		Returns the full Type name of the exception that has occurred.
This.FindExtension		Finds an extension macro.
This.GetParameter	✓	Gets the value of the given parameter/property.
This.ParameterExists	✓	Checks whether the given parameter/property is set.
This.Result		Returns the result of the macro. Typically used in the ResultFormat property, to format, convert or encode the result.
This.SXMLPath		Gets the path to the macro in the current execution stack.

Remarks

Smartsite SXML	Copy Code
<json id="json"></json>

Smartsite SXML	Copy Code
<json id="json">{"name":"Jason"}</json>

Smartsite SXML	Copy Code
<json id="requestJson" />

Examples

Smartlet Example

Here's a largish example of a working smartlet. It's described in more detail here.

Smartsite SXML	Copy Code
<se:switch expression="translation.arg(1,rem='Use "init" to add all the plumbing to your form, "set" to get the value of a control taking the zip code from posted data.')" > <se:case value="init"> {buffer.set('formId',translation.arg(2,rem='Id of the enriched form'))} {buffer.set('zipControl',translation.arg(3,rem='Name of the zip code control'))} {buffer.set('streetControl',translation.arg(4,rem='Name of the street control for mode init, name of the requested value for mode set.'))} {buffer.set('cityControl',translation.arg(5,rem='Name of the street control'))} <!--// Initialize javascript for enrichment --> {placeholder.addjavascriptonload("$get('addrInvulKnop').style.display='none';")} {placeholder.addjavascriptonload("$addHandler(getZip(), 'change', PostWebRequest);")} <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/MicrosoftAjax.js" /> <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/MicrosoftAjaxWebForms.js" /> <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/Toolkit/Common.js" /> <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/Toolkit/BaseScripts.js" /> <se:placeholder.addjavascriptinclude url="{channel.link('JS_ZIPCODE')}" /> <se:placeholder.addjavascript> function getZip(){ return $get("{buffer.get('formId')}").elements["{buffer.get('zipControl')}"]; } function getStreet(){ return $get("{buffer.get('formId')}").elements["{buffer.get('streetControl')}"]; } function getCity(){ return $get("{buffer.get('formId')}").elements["{buffer.get('cityControl')}"]; } // This function performs a POST Web request. function PostWebRequest() { pwr("{channel.link(translation.number())}"); } </se:placeholder.addjavascript> <input type="submit" id="addrInvulKnop" name="updateAddress" value="Adres invullen" /> </se:case> <se:case value="set" whitespace="remove"> {buffer.set('zipControl',translation.arg(3,rem='Name of the zip code control'))} <!--// TODO: Harden against SQL injection --> {buffer.set('requestedValue',translation.arg(4,rem='Name of the street control for mode init, name of the requested value for mode set.'))} <se:sqlquery condition="request.form(buffer.get('zipControl'),default='')!=''" sql="select {buffer.get('requestedValue',whitespace='normalize')} from zipcodes where zipcode='{request.form(buffer.get(zipControl))}'"> <se:parameters> <se:parameter name="rowformat">{this.field(1)}</se:parameter> </se:parameters> </se:sqlquery> </se:case> <se:case whitespace="remove"> <!--// Handle postback --> <se:json /> <se:if expression="page.json.exists('zip')"> <se:then> <se:sqlquery whitespace="preserve"> <se:parameters> <se:parameter name="sql"> select street, city from zipcodes where zipcode=? </se:parameter> <se:parameter name="params">{page.json.getvalue('zip')}</se:parameter> <se:parameter name="format"> <se:rowformat match="first">"city":"{this.field(city)}","street":"{this.field(street)}"</se:rowformat> <se:rowformat></se:rowformat> </se:parameter> <se:parameter name="resultformat">{{this.result()}}</se:parameter> </se:parameters> </se:sqlquery> {response.contenttype('application/json')} </se:then> <se:else> {response.redirect(4216)} </se:else> </se:if> </se:case> </se:switch>

Smartsite SXML

Copy Code

<se:switch expression="translation.arg(1,rem='Use &quot;init&quot; to add all the plumbing to your form,
    &quot;set&quot; to get the value of a control taking the zip code from posted data.')"
    >
    <se:case value="init">
        {buffer.set('formId',translation.arg(2,rem='Id of the enriched form'))}
        {buffer.set('zipControl',translation.arg(3,rem='Name of the zip code control'))}
        {buffer.set('streetControl',translation.arg(4,rem='Name of the street control for mode init, name of the requested value for mode set.'))}
        {buffer.set('cityControl',translation.arg(5,rem='Name of the street control'))}
        <!--// Initialize javascript for enrichment -->
        {placeholder.addjavascriptonload("$get('addrInvulKnop').style.display='none';")}
        {placeholder.addjavascriptonload("$addHandler(getZip(), 'change', PostWebRequest);")}
        <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/MicrosoftAjax.js" />
        <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/MicrosoftAjaxWebForms.js" />
        <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/Toolkit/Common.js" />
        <se:placeholder.addjavascriptinclude url="/AJAX/Scripts/Toolkit/BaseScripts.js" />
        <se:placeholder.addjavascriptinclude url="{channel.link('JS_ZIPCODE')}" />
        <se:placeholder.addjavascript>
            function getZip(){
                return $get("{buffer.get('formId')}").elements["{buffer.get('zipControl')}"];
            }
            
            function getStreet(){
                return $get("{buffer.get('formId')}").elements["{buffer.get('streetControl')}"];
            }
            
            function getCity(){
                return $get("{buffer.get('formId')}").elements["{buffer.get('cityControl')}"];
            }
        
            // This function performs a POST Web request.
            function PostWebRequest()
            {
                pwr("{channel.link(translation.number())}");
            }
        </se:placeholder.addjavascript>
        <input type="submit" id="addrInvulKnop" name="updateAddress" value="Adres invullen" />
    </se:case>
    <se:case value="set" whitespace="remove">
        {buffer.set('zipControl',translation.arg(3,rem='Name of the zip code control'))}
        <!--// TODO: Harden against SQL injection -->
        {buffer.set('requestedValue',translation.arg(4,rem='Name of the street control for mode init, name of the requested value for mode set.'))}
        <se:sqlquery 
            condition="request.form(buffer.get('zipControl'),default='')!=''"
            sql="select {buffer.get('requestedValue',whitespace='normalize')} from zipcodes where zipcode='{request.form(buffer.get(zipControl))}'">
            <se:parameters>                
                <se:parameter name="rowformat">{this.field(1)}</se:parameter>
            </se:parameters>
        </se:sqlquery>
    </se:case>
    <se:case whitespace="remove">
        <!--// Handle postback -->
        <se:json />
        <se:if expression="page.json.exists('zip')">
            <se:then>
                <se:sqlquery whitespace="preserve">
                    <se:parameters>
                        <se:parameter name="sql">
                            select street, city from zipcodes where zipcode=?
                        </se:parameter>
                        <se:parameter name="params">{page.json.getvalue('zip')}</se:parameter>
                        <se:parameter name="format">
                            <se:rowformat match="first">"city":"{this.field(city)}","street":"{this.field(street)}"</se:rowformat>
                            <se:rowformat></se:rowformat>
                        </se:parameter>
                        <se:parameter name="resultformat">{{this.result()}}</se:parameter>
                    </se:parameters>
                </se:sqlquery>
                {response.contenttype('application/json')}
            </se:then>
            <se:else>
                {response.redirect(4216)}
            </se:else>
        </se:if>
    </se:case>
</se:switch>

Ajax Call Example

The code in the example will return a JSON object to the client containing an array with name, description pairs of all terms in the glossary of the site. This list can then be used to annotate glossary terms on the client.

Smartsite SXML	Copy Code
<se:hidden> <se:json id="list">{"glossary":[]}</se:json> <se:json id="term">{"n":"", "d":""}</se:json> <se:sqlquery> <se:parameters> <se:parameter name="sql"> select name, description from vwGlossary </se:parameter> <se:parameter name="rowformat"> {page.term.set(n, this.field(1), "string")} {page.term.set(d, string.normalizewhitespace(this.field(2)), "string")} {page.list.add(glossary, page.term.get())} </se:parameter> </se:parameters> </se:sqlquery> </se:hidden>{page.list.get(glossary, true, default='null', error='null')} {response.contenttype(page.list.mimetype())}

Smartsite SXML

Copy Code

<se:hidden>
    <se:json id="list">{"glossary":[]}</se:json>
    <se:json id="term">{"n":"", "d":""}</se:json>
    <se:sqlquery>
        <se:parameters>
            <se:parameter name="sql">
                select name, description from vwGlossary
            </se:parameter>
            <se:parameter name="rowformat">
                {page.term.set(n, this.field(1), "string")}
                {page.term.set(d, string.normalizewhitespace(this.field(2)), "string")}
                
                {page.list.add(glossary, page.term.get())}
            </se:parameter>
        </se:parameters>
    </se:sqlquery>
</se:hidden>{page.list.get(glossary, true, default='null', error='null')}
{response.contenttype(page.list.mimetype())}

More examples

SXML