Download API data that returns JSON format within XML

Question

I am accessing a website that provides an API that returns the data in JSON format, but the data is returned inside an XML code in the format below:

<string xmlns="http://tempuri.org/">[arquivo JSON]</string>

How to extract this JSON file from within XML code?

Answer 1

Try something like that:

    library(xml2)
library(magrittr)
library(jsonlite)

url <- "http://site/api/transparencia.asmx/json_frota_veiculos?fbclid=IwAR3YRmwhEGVcePgavCUDwsCmeb_Z4ddgIwTH8Lp5Gv5elTy6fXRixkHFHeE"

page <- read_xml(url) %>% 
xml_text() %>% 
fromJSON()