I am using some API calls to grab form submissions from HubSpot. I am having some trouble sorting the Json file that comes back. I basically want to take the most recent submission only. The text looks like this:
It seems that the Json Data provided had a missing curly braces which was making the json as invalid.
But on correction of the format, we can get the validated data in a Json Object by performing a Deserialization using the Deserialize Json Activity.
For this we would need to understand, what is meant by the recent submission, Is it the first data present in the json ? Also, If you could provide the Expected Output that you require from this data, we could provide suggestions on retrieving the same.
Thanks for the help. I know i need to deserialize. My trouble came in when trying to parse specific data. In the case of the above what I want to take out and put into an excel doc is firstname,Vinny then Lastname,LaRocca and so on. Trying to use myJObject.SelectToken(“”).tostring did not work to for finding anything.
If I wanted to put “Vinny” into a variable, how could I do that?
This is what I have right now. The next step I need to preform is to assign variables I can use in an excel doc. I created variables firstName, lastName, email, company and industry. In this case I want to assign firstName = Vinny, lastName = LaRocca and so on.
We have understood the format, but we still do not have a confirmation on the recent submission value. Do we take it as mentioned by @ppr in his post above or is it just the first item from the values array that we would need to consider ?
Maybe a Total Data (Values) Conversion to Datatable sorted by recent submission value would be beneficial, Which we could then perform the filtration of the required data from it :
The methods used in the workflow are corresponding to the methods mentioned above in Peter’s Post. Json_ConvertToDatatable.zip (4.1 KB)
For a First Row Requirement, we could modify the Datatable input to Write Range / modify the Datatable itself using an Assign in the below manner :
Let us know if you are able to follow the workflow or facing any issues.