Json Data Editing

Unknown

Json Data Editing

Unknown

Im new with Decision and i started a project Yesterday. The first is : Scrap a JSON String from an API -> Deserialize this Json which is a List of identical Object -> Remove a number a useless property of each of those object -> Add 1 property (an constant integer) to each object in the list.

So first Ive used a Get with Rest to scrap my data and with a Json Deserializer i got in ouput my List of Object. But, for several hours i tried to figure out a way to achieve the last 2 steps without succeeding .. Do you have an idea how to proceed ?
[i]edited by mikhelil on 8/27/2020[/i]

Unknown

Hello,

I Have you created a data structure to contain your custom JSON data after its been deserialized?

Essentially, the steps you should follow is:

• Create a data structure that defines your JSON data. This structure is used to contain your deserialized data.
• Receive your JSON data from your REST API

• Pass the JSON data into the deserialize step. Make sure that your data is being returned as the data type that reflects your data structure.

• Use the "create data" step to create a new instance of a list of your data type. Then use a foreach step to cycle through your results from the deserialize step. Using the "Add Item To List" step, add your desired results into the new created list of your data type.

• When using the Add Item to List step, you can use "Edit Input Mapping" feature to map in a constant value to your data structure.

If you require help implementing this, or if the instructions dont quite align with what youre trying to do, let us know!

Unknown

Hello ! Thank you for your answer.\r\n\r\nYes, i have created 2 Data Structure, one is the object \"Car\" with all the properties of each \"Car\" and the other one is a list of \"Car\".\r\n\r\nConcerning the steps : \r\n- The Output of my Json Deserialize Step is problematic. Indeed, when I use \"Edit Mapping Input\" I can't select \"All Car\" (which are my object) but i can only select \"All Id\

Unknown

Hello ! Its me again
I successfully did all i wanted to do in my first post. Now my flow work just fine. But, i have in OutPut a List of object (Object that I have created with a Data Structure) and I want to save this Data in a "Permanent" Database (1) and Export it on a GoogleSheet (2).

(1) For this point, I have an Azure Database that i have sat up in Decision. Ive created a Table that fit my Object. But what step should i use to do stove/save this data ?
(2) For this point, i want to export my list of object on a Gsheet, is it possibler with Decisionn and how should i do it ?

I thank you in advance for your time !