Load .JSON data into application (like Excel Record)
Question

Hello,

Let's say I have a .json, not a WebService but a .json file, which I want to iterate and add it's data to my database, the same way I can import an excel and iterate it's data, I want to do the same with a json file.


How can I achieve this?


Cheers

Solution

Hello Fábio,

Going to the structures you can create the structure based on the JSON you have. Like that you'll have the structure to transform the Json to the Structure.

After you get the structure built on, based on the JSON you can use the function Json Deserialize.

Like this, everytime you give the string (JSON) it will return the structure. After that you need to built extra-logic to create the data on the database. Notice that for excel file, there's also logic behind it, but it's built with the scaffolding, for the JSON there's no such thing, you need to built it.

I believe this topic is a duplicate or similar of this one.

Hope it helps. Cheers!

Could you be more specific if we talkin about this JSON data?

I have the same issue but also the problem.

The problem is with json it self

it doesn't matter if I'm using the file 

or worst the static text

What is the correct format of this string?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.