User:Alex skene/scratchpad/more external stuff: Difference between revisions

From FOIwiki
Jump to navigationJump to search
Line 72: Line 72:


{{#for_external_table:<nowiki/>
{{#for_external_table:<nowiki/>
* {{{id}}} / {{{name}}} / {{{url_name}}} / {{{tags}}}
* {{{id}}} / {{{name}}} / {{{url_name}}} / {{{tags}}} / {{{short_name}}} / {{{publication_scheme}}} / {{{created_at}}} / {{{notes}}} / {{{home_page}}}
}}
}}

Revision as of 22:55, 30 January 2012

try xml

{{#get_external_data:http://www.legislation.gov.uk/ukpga/2000/36/section/11/data.xml |xml |Pnumber=Pnumber |P1para=P1para |P2para=P2para |P3para=P3para |P4para=P4para |Text=Text |}}

{{#for_external_table:

  • {{{Pnumber}}} / {{{Text}}} / {{{P1para}}}

}}

  • the legislation xml doesn't meet the SMW extension's format v well, so won't e able format properly

try xht format

{{#get_external_data:http://www.legislation.gov.uk/ukpga/2000/36/section/11/data.xht |xml |span=span |class=class |}}


{{#for_external_table:

  • {{{span}}} / {{{class}}}

}}

try json format

1:

{{#get_web_data: url=http://www.whatdotheyknow.com/request/bnp_teachers_152.json |format=json |data=url_title=url_title,title=title,id=id }}


{{#for_external_table:

  • {{{url_title}}} / {{{title}}} / {{{id}}}

}}

2:

{{#get_web_data: url=http://api.scraperwiki.com/api/1.0/datastore/sqlite?format=jsondict&name=ico_lines_to_take&query=select%20*%20from%20ltt_data |format=json |data=snippet=snippet }}


{{#for_external_table:

  • {{{snippet}}}

}}

3:

{{#get_web_data: url=http://www.whatdotheyknow.com/body/tfl.json |format=json |data=notes=notes,publication_scheme=publication_scheme,updated_at=updated_at,created_at=created_at,tags=tags,home_page=home_page,name=name,url_name=url_name,id=id,short_name=short_name }}

{{#for_external_table:

  • {{{id}}} / {{{name}}} / {{{url_name}}} / {{{tags}}} / {{{short_name}}} / {{{publication_scheme}}} / {{{created_at}}} / {{{notes}}} / {{{home_page}}}

}}