I have file available in two formats: JSON and CSV. As I understand work with JSON more easily nether than CSV. Could you please advice how work with that format. File contains this kind of information:
For the begining I want to render this information into html. In future probably do some manipulation (search, CRUD operation, do some analytics). This data can be providing as site api in JSON / CSV format, and as file in JSON / CSV format.
Ok, I would suggest you use Json.NET which is included with Umbraco to deserialize your data from Json to C# models or to it's own JObjects. You can find info on Json.NET here
Fetch data from JSON or CSV file
Hello,
I have file available in two formats: JSON and CSV. As I understand work with JSON more easily nether than CSV. Could you please advice how work with that format. File contains this kind of information:
"name": "Films", "count": 84, "frequency": "realtime", "version": 1, "newdata": true, "lastrunstatus": "success", "lastsuccess": "Wed Jul 02 2014 04:50:41 GMT+0000 (UTC)", "results": { "collection1": [ { "Film": { "text": "WTF! Какого черта?" }, "Time": [ "Время", "11:00", "14:50", "16:40", "20:30" ], "Format": [ "Формат", "-", "-", "-", "-" ], "Cost for adult": [ "Взрослый", "700", "900", "1100", "1300" ], "Cost for child": [ "Детский", "-", "-", "-", "-" ], "Cost for students": [ "Студент.", "500", "-", "-", "-" ], "Cost for VIP": [ "VIP", "-", "-", "-", "-" ], "Language": [ "Язык", "-", "-", "-", "-" ] }, ...What do you want to do with this data and where is it coming from, a property editor?
For the begining I want to render this information into html. In future probably do some manipulation (search, CRUD operation, do some analytics). This data can be providing as site api in JSON / CSV format, and as file in JSON / CSV format.
Ok, I would suggest you use Json.NET which is included with Umbraco to deserialize your data from Json to C# models or to it's own JObjects. You can find info on Json.NET here
is working on a reply...