Accept JSON as Input and Modify with <script>
If you need to manipulate a JSON variable in a mashup or macro without converting the data to XML, you must use JavaScript in the <script> statement. You can also accept a JSON object as an input parameter, such as this example macro:
...
<macro name="getFirstJsonCity" >
<output name="cityStats" type="document" subtype="JSON"/>
<input name="jsonCities" type="document" subtype="JSON"/>
<script type="text/javascript" inputvariables="jsonCities"
outputvariable="cityStats">
<![CDATA[
var jsonObj = JSON.parse(jsonCities);
cityStats = JSON.stringify(jsonObj.locations[1]);
]]>
</script>
</macro>
...
This example is a macro, but you can use these same techniques in a mashup also.
Contact Support
|
Community
|
Feedback