You’re offline. This is a read only version of the page.
44
Hello,
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.
Share
Report{
"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"
}
]
}
Hi @Alexlorenzo21 ,
Do you want to get the data in the array of employees?
Perhaps you could try the following method:
Expression:
All responses (
Answers (
variables('Response')['employees']
For example, id and employeeNumber should be obtained as below, Expression reference:
items('Apply_to_each')['id']
items('Apply_to_each')['employeeNumber']
Image reference:
Please take a try.
Best Regards,
