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

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


{{#get_web_data:
{{#get_web_data:
url=http://www.whatdotheyknow.com/feed/search/requested_from:tfl.json
url=http://www.whatdotheyknow.com/feed/body/islington_borough_council.json
|format=json
|format=json
|data=rcalculated_state=calculated_state,rinfo_request=info_request,rid=id,rtitle=title,rurl_title=url_title,rdisplay_status=display_status
|data=rcalculated_state=calculated_state,rinfo_request=info_request,rid=id,rtitle=title,rurl_title=url_title,rdisplay_status=display_status

Revision as of 01:31, 1 February 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/feed/body/islington_borough_council.json |format=json |data=rcalculated_state=calculated_state,rinfo_request=info_request,rid=id,rtitle=title,rurl_title=url_title,rdisplay_status=display_status }}

{{#for_external_table:

  • {{{rid}}} / {{{rcalculated_state}}} / {{{rinfo_request}}} / {{{rtitle}}} / {{{rurl_title}}} / {{{rdisplay_status}}}

}}