I am reading an API data in R however this is my first time dealing with this kind of unarranged data. I need some feedbacks on how to parse the data from API.
For accessing the API i am using the following code:
library(httr)
url <- "api url"
take <- GET(url)
details <- content(take,"parsed")
The result i am getting in console shows me a long pattern just like following, though i am sharing few lines. Note that the headers (what i expect) after the $ sign are repeating for multiple entries.
[[502]]$Company
[1] "ABC"
[[502]]$Email
[1] "Not available"
[[502]]$Address
[1] "blah blah"
[[502]]$Name
[1] "blah blah"
[[502]]$Account
ABC
Now i want them to bring into a data frame and arrange them in some manner (sequentially or alphabetically) and need some code for that.
Much Appreciated for help.