Share
Report
44Hello,
I am having a really hard time figuring out how create this flow.
I want to parse the following json response below.
The end result I am trying to do is to enter the "employees" table data into a SQL server table.
The response of the GET API call is the following.
{
"title": "compensation date",
"fields": [
{
"id": "employeeNumber",
"type": "employee_number",
"name": "Employee #"
},
{
"id": "fullName2",
"type": "text",
"name": "Last Name, First Name"
},
{
"id": "firstName",
"type": "text",
"name": "First Name"
},
{
"id": "lastName",
"type": "text",
"name": "Last Name"
},
{
"id": "payRateEffectiveDate",
"type": "date",
"name": "Compensation: Date"
},
{
"id": "payType",
"type": "pay_type",
"name": "Pay type"
},
{
"id": "payRate",
"type": "currency",
"name": "Pay rate"
},
{
"id": "payPer",
"type": "paid_per",
"name": "Paid per"
},
{
"id": "jobTitle",
"type": "list",
"name": "Job Title"
},
{
"id": "department",
"type": "list",
"name": "Department"
},
{
"id": "division",
"type": "list",
"name": "Division"
}
],
"employees": [
{
"id": "40525",
"employeeNumber": "144216",
"fullName2": "XXXX",
"firstName": "XXXX",
"lastName": "XXXX",
"payRateEffectiveDate": "2015-01-01",
"payType": "Salary",
"payRate": " XXXX",
"payPer": null,
"jobTitle": "XXXXXXXX",
"department": "XXXXXXXX",
"division": "XXXXXXXX"
},
{
"id": "40535",
"employeeNumber": "153444",
"fullName2": "XXXX, XXXX",
"firstName": "XXXX",
"lastName": "XXXX",
"payRateEffectiveDate": "2016-11-01",
"payType": "Hourly",
"payRate": "19.50 USD",
"payPer": "Hour",
"jobTitle": "XXXX",
"department": "XXXXXXXX",
"division": "XXXXXXXX"
}
]
}
Categories:
I have the same question (0)
All responses (
Answers (
