The free Version of the JSON Content Importer-Plugin is based on the proprietary “JCI-parser” with some great features. This is good and still available.
But: If you want to have full control of your JSON, build applications etc. you need a better parser. For this the pro-plugin comes with the popular Twig-engine (https://twig.symfony.com/doc/1.x/templates.html).
The usage is as following:
After getting access to the JSON-data the PRO plugin can suggest you twig-code for displaying all the JSON-data.
For that create a template with the URL and maybe needed accessdata so that JSON is available. Leave the template empty and switch on the debugmode.
Preview the page and see the twig-code generated.
How to use Twig:
You can use Twig-code just the way as with jci-template-code in the free plugin (ok, but not recommended: use the PRO plugin-template, see below)
Example-Shortcode:
[jsoncontentimporterpro url=http://... parser=twig]
{% for eventitem in event %}
{% if eventitem.evs3|length > 0 %}
{{eventitem.eventname}}
{% endif %}
{% endfor %}
[/jsoncontentimporterpro]
The better way is to use Twig via the PRO plugin-templates:.
In short: Twig code is in the PRO plugin-template with Number NO. Then the Shortcode is as simple like this:
[jsoncontentimporterpro id=NO]
Twig-syntax:
- Twig is documented in detail here
- “Twig fiddle” is also great: Build and test your Twig-syntax together with your JSON
Sometimes the devil is in the detail:
- Handle dash in twig and JSON
- twig: Loop with key and value
- name of the loop: _context
- Nested Shortcodes
Twig has many powerful commands, but sometimes more is needed. Therefore in the PRO plugin several additional Twig-extensions are added:
- sort: “sortbyjsonfield”: Sort JSON by chars, numbers or dates
- format date: By “dateformat” you can set timezone and language / locale of time- and date-output. See example here.
- format number: “formatnumber(decimals, dec_point, thousands_sep)” formats numerical JSON-data
- “convert2html”: convert JSON-data into HTML
- “converthex2ascii”: convert hex-data from JSON to ascii
- “removespecialcharsinurl”: build URLs by lower strings, replacing blanks into dashes, converting “ä” into “ae” etc.
- “stringshorter(length, suffix)”: cut a string to length and put a suffix (e.g. “…”) at the end. This is useful for creating a Teasertext out of a long text
- “htmlspecialchars_decode”: like the PHP-function “htmlspecialchars-decode”
- “base64encode”: like the PHP-function “base64_encode”
- “htmlentities”: like the PHP-function “htmlentities”
- “removenonprintable”: strip everything except basic printable ASCII characters by preg_replace( ‘/[^[:print:]]/’, replacement, input)
- “preg_replace”:
- “md5”: like the PHP-function “md5”
- “dump”: output JSONARRAY by PHP-syntax print_R(JSONARRAY, TRUE)
- Usage of twig for JSON starting with “[{“: See twig and it’s _context