Hi All,
Hoping you are able to help with the following
Aim : To Output the URL Json String into a text file.
Observations : I have the following R config, which calls an API and and it returns a Json string. Whilst outputting the data into a txt file i have noticed its trimming my URL response.
Adding a browse tool to the connection 2 it has the following ;
Data Type V_WStrong
Size 1073741823
library (readr)
library (rjson)
urlfile="https://api.gleif.org/api/v1/fuzzycompletions?field=entity.legalName&q=hacker"
mydata<-read_tsv(url(urlfile))
write.Alteryx(mydata,nOutput = 1)
write.Alteryx(as.data.frame(mydata), 2)
Looking forward to your response
Kind Regards
