Root Path for Json
Hello,
I'm using HTTP Get node to connect to Databricks catalog and I can see the data in the format:
{"statement_id":"xyz","status":{"state":"SUCCEEDED"},
"manifest":{"format":"JSON_ARRAY",
"schema":{"column_count":2,"columns":[{"name":"account_id","type_text":"STRING","type_name":"STRING","position":0},
{"name":"account_description","type_text":"STRING","type_name":"STRING","position":1}]},"total_chunk_count":1,"chunks":[{"chunk_index":0,"row_offset":0,"row_count":2}],
"total_row_count":2,"truncated":false}, "result":{"chunk_index":0,"row_offset":0,
"row_count":2,
"data_array":[["1234","abc"],["5678","xzy"]] }}
However when I try to use JSON to CSV node to convert the data before I load to Wdata table I keep getting the error. 'Result: Error: path not found.'
What should be the appropriate 'Path to root' and 'Column mappings to JSON Path' in this case?
Appreciate your help !!
U moet u aanmelden om een opmerking te plaatsen.
Opmerkingen
0 opmerkingen