JSON problems (API) - R scriptSafely turning a JSON string into an objectHow do I format a Microsoft JSON date?Can comments be used in JSON?How can I pretty-print JSON in a shell script?What is the correct JSON content type?Why does Google prepend while(1); to their JSON responses?Why can't Python parse this JSON data?How can I pretty-print JSON using JavaScript?Parse JSON in JavaScript?How do I POST JSON data with Curl from a terminal/commandline to Test Spring REST?
Some numbers are more equivalent than others
Have I saved too much for retirement so far?
Engineer refusing to file/disclose patents
Would it be legal for a US State to ban exports of a natural resource?
Should I install hardwood flooring or cabinets first?
How do I implement a file system driver driver in Linux?
Difference between -| and |- in TikZ
Could the E-bike drivetrain wear down till needing replacement after 400 km?
Indicating multiple different modes of speech (fantasy language or telepathy)
We have a love-hate relationship
Is camera lens focus an exact point or a range?
Translation of Scottish 16th century church stained glass
Proving a function is onto where f(x)=|x|.
Greatest common substring
How much character growth crosses the line into breaking the character
Visiting the UK as unmarried couple
Has Darkwing Duck ever met Scrooge McDuck?
Can the Supreme Court overturn an impeachment?
Does having a TSA Pre-Check member in your flight reservation increase the chances that everyone gets Pre-Check?
Journal losing indexing services
Will adding a BY-SA image to a blog post make the entire post BY-SA?
What is this type of notehead called?
Transformation of random variables and joint distributions
Can somebody explain Brexit in a few child-proof sentences?
JSON problems (API) - R script
Safely turning a JSON string into an objectHow do I format a Microsoft JSON date?Can comments be used in JSON?How can I pretty-print JSON in a shell script?What is the correct JSON content type?Why does Google prepend while(1); to their JSON responses?Why can't Python parse this JSON data?How can I pretty-print JSON using JavaScript?Parse JSON in JavaScript?How do I POST JSON data with Curl from a terminal/commandline to Test Spring REST?
I want to unlist JSON data and generate output which contains columns parameter and its value, but my script doesn't generate parameter name (like for example: "@Role"). It only generates number.
Script:
library(jsonlite)
json <- fromJSON("https://api.elsevier.com/content/search/affiliation?query=affil(Broad%20Institute)&apiKey=7f59af901d2d86f78a1fd60c1bf9426a")
json <- data.frame(unlist(json))
json$rownames <- rownames(json)
JSON: (longer version JSON data is here -> https://dev.elsevier.com/scopus.html#!/Affiliation_Search/AffiliationSearch -> Affiliation_Search -> Try it out -> Response Body
But shorter version ...
Response Body
{
"search-results": {
"opensearch:totalResults": "277",
"opensearch:startIndex": "0",
"opensearch:itemsPerPage": "25",
"opensearch:Query":
"@role": "request",
"@searchTerms": "affil(Broad Institute)",
"@startPage": "0"
,
"link": [
"@_fa": "true",
"@ref": "self",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "first",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "next",
"@href": "https://api.elsevier.com/content/search/affiliation?start=25&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "last",
"@href": "https://api.elsevier.com/content/search/affiliation?start=252&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
],
json
add a comment |
I want to unlist JSON data and generate output which contains columns parameter and its value, but my script doesn't generate parameter name (like for example: "@Role"). It only generates number.
Script:
library(jsonlite)
json <- fromJSON("https://api.elsevier.com/content/search/affiliation?query=affil(Broad%20Institute)&apiKey=7f59af901d2d86f78a1fd60c1bf9426a")
json <- data.frame(unlist(json))
json$rownames <- rownames(json)
JSON: (longer version JSON data is here -> https://dev.elsevier.com/scopus.html#!/Affiliation_Search/AffiliationSearch -> Affiliation_Search -> Try it out -> Response Body
But shorter version ...
Response Body
{
"search-results": {
"opensearch:totalResults": "277",
"opensearch:startIndex": "0",
"opensearch:itemsPerPage": "25",
"opensearch:Query":
"@role": "request",
"@searchTerms": "affil(Broad Institute)",
"@startPage": "0"
,
"link": [
"@_fa": "true",
"@ref": "self",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "first",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "next",
"@href": "https://api.elsevier.com/content/search/affiliation?start=25&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "last",
"@href": "https://api.elsevier.com/content/search/affiliation?start=252&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
],
json
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18
add a comment |
I want to unlist JSON data and generate output which contains columns parameter and its value, but my script doesn't generate parameter name (like for example: "@Role"). It only generates number.
Script:
library(jsonlite)
json <- fromJSON("https://api.elsevier.com/content/search/affiliation?query=affil(Broad%20Institute)&apiKey=7f59af901d2d86f78a1fd60c1bf9426a")
json <- data.frame(unlist(json))
json$rownames <- rownames(json)
JSON: (longer version JSON data is here -> https://dev.elsevier.com/scopus.html#!/Affiliation_Search/AffiliationSearch -> Affiliation_Search -> Try it out -> Response Body
But shorter version ...
Response Body
{
"search-results": {
"opensearch:totalResults": "277",
"opensearch:startIndex": "0",
"opensearch:itemsPerPage": "25",
"opensearch:Query":
"@role": "request",
"@searchTerms": "affil(Broad Institute)",
"@startPage": "0"
,
"link": [
"@_fa": "true",
"@ref": "self",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "first",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "next",
"@href": "https://api.elsevier.com/content/search/affiliation?start=25&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "last",
"@href": "https://api.elsevier.com/content/search/affiliation?start=252&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
],
json
I want to unlist JSON data and generate output which contains columns parameter and its value, but my script doesn't generate parameter name (like for example: "@Role"). It only generates number.
Script:
library(jsonlite)
json <- fromJSON("https://api.elsevier.com/content/search/affiliation?query=affil(Broad%20Institute)&apiKey=7f59af901d2d86f78a1fd60c1bf9426a")
json <- data.frame(unlist(json))
json$rownames <- rownames(json)
JSON: (longer version JSON data is here -> https://dev.elsevier.com/scopus.html#!/Affiliation_Search/AffiliationSearch -> Affiliation_Search -> Try it out -> Response Body
But shorter version ...
Response Body
{
"search-results": {
"opensearch:totalResults": "277",
"opensearch:startIndex": "0",
"opensearch:itemsPerPage": "25",
"opensearch:Query":
"@role": "request",
"@searchTerms": "affil(Broad Institute)",
"@startPage": "0"
,
"link": [
"@_fa": "true",
"@ref": "self",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "first",
"@href": "https://api.elsevier.com/content/search/affiliation?start=0&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "next",
"@href": "https://api.elsevier.com/content/search/affiliation?start=25&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
,
"@_fa": "true",
"@ref": "last",
"@href": "https://api.elsevier.com/content/search/affiliation?start=252&count=25&query=affil%28Broad+Institute%29&apiKey=7f59af901d2d86f78a1fd60c1bf9426a",
"@type": "application/json"
],
json
json
edited Mar 8 at 7:36
Blossfeld
asked Mar 8 at 7:08
BlossfeldBlossfeld
11
11
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18
add a comment |
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55058347%2fjson-problems-api-r-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55058347%2fjson-problems-api-r-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hi and welcome to StackOverflow! I'm sorry, but I don't understand what you are asking here. What language is your script? What does the JSON input look like. What do you want to achieve with the script? Please edit your question and add examples. If in doubt make sure to read How to Ask.
– lupz
Mar 8 at 7:18