JCI and Google Spreadsheet


You have a Google spreadsheet with data. Publish this Spreadshirt as CSV.
With that, you get something like

Show this data:

Create a JCI-Template with

name: googlespreadsheet

URL: see above

Curl options:



<table border=1>
{% for k,v in _parent %}
        {% for i in 0..((v | length)-1) %}
            {% set out = attribute(v, i) %}
        {% endfor %}
{% endfor %}


[jsoncontentimporterpro nameoftemplate=googlespreadsheet inputtype=csv inputtypeparam='{"delimiter": ",", "enclosure": "#QM#", "escape":"#BS#", "csvline": "#LF#", "skipempty": "yes"}']
Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
On this page: