I am using the Quandl API to return commodity price data. The integration is not able to convert the response body into an appian value, and a!toJson / a!fromJason are not able to handle the text input either.
The result of the body is as follows:
body: "{"dataset_data":{"limit":1,"transform":null,"column_index":null,"column_names":["Date","Open","High","Low","Last","Change","Settle","Volume","Previous Day Open Interest"],"start_date":"1983-03-30","end_date":"2019-03-15","frequency":"daily","data":[["2019-03-15",58.51,58.95,57.74,58.39,0.09,58.52,501635.0,134939.0]],"collapse":null,"order":"desc"}}"
I am not sure how to resolve this issue. Does anyone have any experience?
Discussion posts and replies are publicly visible
Seems like list of lists if not supported by a!fromJSON
Expression evaluation error at function a!fromJson [line 7]: Cannot transform input in to an Appian type because it contains a list of lists.
See if you can structure the JSON more at the source so that JSON doesn't have the list of lists. And, to parse JSON use a!jsonPath, should work for list of lists.
a!jsonPath( ri!yourJson, "dataset_data.data" )