Jump to content

I am converting JSON to datatable in R data function in spotfire and i am getting bellow error.


Recommended Posts

Posted

Error - TIBCO Enterprise Runtime for R returned an error: 'Error in .cleanDataForExport(value, output.name) : Output data 'Data$COUNTRY_ID' has illegal type: 'list''.

Here is the JSON -

[{"COUNTRY_ID":[356],"OWNER_TYPE":{},"STORE_CONTACT1":{},"STORE_NAME":["BAQALA NEW ZANBAQ"],"OWNER_NAME":{},"ZIPCODE":{},"STREET_NAME":["MUROOR ROAD"],"STORE_TYPE":["OLA"],"STORE_ID":["GSR_31937350"]},{"COUNTRY_ID":[356],"OWNER_TYPE":{},"STORE_CONTACT1":{},"STORE_NAME":["HASSAN AHMED SAQER GROCERY"],"OWNER_NAME":{},"ZIPCODE":{},"STREET_NAME":["AL QUOZ IND-1"],"STORE_TYPE":["LARGE GROCERY"],"STORE_ID":["GSR_31937351"]},{"COUNTRY_ID":[356],"OWNER_TYPE":{},"STORE_CONTACT1":{},"STORE_NAME":["NEW KHORFAKAN PEOPLES RESTAURANT"],"OWNER_NAME":{},"ZIPCODE":{},"STREET_NAME":["SULTHAN BIN ZAYED THE FIRST"],"STORE_TYPE":["ZZZ"],"STORE_ID":["GSR_31938370"]},{"COUNTRY_ID":[356],"OWNER_TYPE":{},"STORE_CONTACT1":{},"STORE_NAME":["ASHANA RESTAURANT(TOB.BOOSTER)"],"OWNER_NAME":{},"ZIPCODE":{},"STREET_NAME":{},"STORE_TYPE":["ZZZ"],"STORE_ID":["GSR_31938385"]},{"COUNTRY_ID":[356],"OWNER_TYPE":{},"STORE_CONTACT1":{},"STORE_NAME":["KHALID AL KANDI RESTAURANT(REV-2013)"],"OWNER_NAME":{},"ZIPCODE":{},"STREET_NAME":["MAHDAR BARR STREET"],"STORE_TYPE":["ORT"],"STORE_ID":["GSR_36968875"]}]

My code is -

require(jsonlite)

fromJSON(JSON)

Any help appreciately

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...