Symphony.

TfL provide their data in a format that's like JSON but not: http://countdown.api.tfl.gov.uk/interfaces/ura/instant_V1

What would be the best way of getting this into a datasource (or event?)? Does anyone have a (very) basic example of how to create XML elements from external data?

Thanks

Remove the square brackets and you have a CSV file. I'd use a basic PHP script to remove these characters, load into fgetcsv, iterate over each row and create XML elements.

Thanks, Nick – I'll give that a bash.