Share
Report
353I have a flow that runs a databricks sql query and returns JSON.
The parse JSON looks like this (full code at the end)
The parse JSON looks like this (full code at the end)
but all I get is this;
how can I access the individual values?
how can I access the individual values?
{
"body": {
"statement_id": "xxxx-38ac-1322-a702-9d8418a33640",
"status": {
"state": "SUCCEEDED"
},
"manifest": {
"format": "JSON_ARRAY",
"schema": {
"column_count": 43,
"columns": [
{
"name": "EmployeeKey",
"type_text": "BIGINT",
"type_name": "LONG",
"position": 0
},
{
"name": "workdayID",
"type_text": "STRING",
"type_name": "STRING",
"position": 1
},
{
"name": "Company",
"type_text": "STRING",
"type_name": "STRING",
"position": 2
},
{
"name": "Company_-_ID",
"type_text": "STRING",
"type_name": "STRING",
"position": 3
},
{
"name": "CompanyIDAdjusted",
"type_text": "STRING",
"type_name": "STRING",
"position": 4
},
{
"name": "Cost_Center",
"type_text": "STRING",
"type_name": "STRING",
"position": 5
},
{
"name": "CF_LH_ELT_Member",
"type_text": "STRING",
"type_name": "STRING",
"position": 6
},
{
"name": "Job_Code",
"type_text": "STRING",
"type_name": "STRING",
"position": 7
},
{
"name": "location",
"type_text": "STRING",
"type_name": "STRING",
"position": 8
},
{
"name": "CF_LH_Location_Rollup_for_Peakon_Integration",
"type_text": "STRING",
"type_name": "STRING",
"position": 9
},
{
"name": "Region",
"type_text": "STRING",
"type_name": "STRING",
"position": 10
},
{
"name": "Employee_ID",
"type_text": "STRING",
"type_name": "STRING",
"position": 11
},
{
"name": "Employer_PAYE_Reference",
"type_text": "STRING",
"type_name": "STRING",
"position": 12
},
{
"name": "Legal_Name_-_First_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 13
},
{
"name": "Legal_Name_-_Last_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 14
},
{
"name": "Legal_Full_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 15
},
{
"name": "Preferred_First_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 16
},
{
"name": "Preferred_Last_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 17
},
{
"name": "Preferred_Full_Name",
"type_text": "STRING",
"type_name": "STRING",
"position": 18
},
{
"name": "primaryWorkEmail",
"type_text": "STRING",
"type_name": "STRING",
"position": 19
},
{
"name": "Gender",
"type_text": "STRING",
"type_name": "STRING",
"position": 20
},
{
"name": "Age",
"type_text": "INT",
"type_name": "INT",
"position": 21
},
{
"name": "dateOfBirth",
"type_text": "DATE",
"type_name": "DATE",
"position": 22
},
{
"name": "Payroll_Employee_Type",
"type_text": "STRING",
"type_name": "STRING",
"position": 23
},
{
"name": "Contingent_Worker_Type",
"type_text": "STRING",
"type_name": "STRING",
"position": 24
},
{
"name": "Currently_Active",
"type_text": "BOOLEAN",
"type_name": "BOOLEAN",
"position": 25
},
{
"name": "Time_in_Position",
"type_text": "STRING",
"type_name": "STRING",
"position": 26
},
{
"name": "Current_Position_Duration",
"type_text": "STRING",
"type_name": "STRING",
"position": 27
},
{
"name": "Current_Employment_Duration",
"type_text": "STRING",
"type_name": "STRING",
"position": 28
},
{
"name": "Position",
"type_text": "STRING",
"type_name": "STRING",
"position": 29
},
{
"name": "Total_FTE",
"type_text": "DECIMAL(10,4)",
"type_name": "DECIMAL",
"position": 30,
"type_precision": 10,
"type_scale": 4
},
{
"name": "Termination_Category",
"type_text": "STRING",
"type_name": "STRING",
"position": 31
},
{
"name": "Termination_Reason",
"type_text": "STRING",
"type_name": "STRING",
"position": 32
},
{
"name": "Original_Hire_Date",
"type_text": "DATE",
"type_name": "DATE",
"position": 33
},
{
"name": "Hire_Date",
"type_text": "DATE",
"type_name": "DATE",
"position": 34
},
{
"name": "Effective_Date_for_Current_Position",
"type_text": "DATE",
"type_name": "DATE",
"position": 35
},
{
"name": "termination_date",
"type_text": "DATE",
"type_name": "DATE",
"position": 36
},
{
"name": "Position_ID",
"type_text": "STRING",
"type_name": "STRING",
"position": 37
},
{
"name": "RecordStart",
"type_text": "TIMESTAMP",
"type_name": "TIMESTAMP",
"position": 38
},
{
"name": "RecordEnd",
"type_text": "TIMESTAMP",
"type_name": "TIMESTAMP",
"position": 39
},
{
"name": "CurrentRecord",
"type_text": "BOOLEAN",
"type_name": "BOOLEAN",
"position": 40
},
{
"name": "Type2SCD",
"type_text": "STRING",
"type_name": "STRING",
"position": 41
},
{
"name": "Type1SCD",
"type_text": "STRING",
"type_name": "STRING",
"position": 42
}
]
},
"total_chunk_count": 1,
"chunks": [
{
"chunk_index": 0,
"row_offset": 0,
"row_count": 5
}
],
"total_row_count": 5,
"truncated": false
},
"result": {
"chunk_index": 0,
"row_offset": 0,
"row_count": 5,
"data_array": [
[
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx"
],
[
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx"
],
[
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
null,
"xxxx",
"xxxx",
null,
null,
"xxxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx",
"xxxx"
]
Categories:
I have the same question (0)
All responses (
Answers (
