Output Results being Trimmed

[Masond3]

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

[Amarendra]

Hi @Masond3 Take a look at this thread here