Issue with api response

jenil.kukadiya · 2024-10-03T12:00:58.601Z

{
“result”: [
{
“attendanceDetails”: {
“2024-08-26”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Janmashtami(Holiday)”,
“FirstIn_Building”: “-”,
“OverTime”: “00:00”,
“LastOut_Location”: “-”,
“ShiftName”: “General”,
“FirstIn”: “-”,
“FirstIn_Location”: “-”,
“TotalHours”: “00:00”,
“WorkingHours”: “08:00”,
“LastOut_Building”: “-”,
“LastOut”: “-”,
“ShiftEndTime”: “12:00 AM”
},
“2024-08-27”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Absent”,
“FirstIn_Building”: “-”,
“LastOut_Location”: “-”,
“ShiftName”: “General”,
“FirstIn”: “-”,
“FirstIn_Location”: “-”,
“TotalHours”: “00:00”,
“WorkingHours”: “00:00”,
“LastOut_Building”: “-”,
“LastOut”: “-”,
“DeviationTime”: “08:00”,
“ShiftEndTime”: “12:00 AM”,
“OverTime”: “02:00”,
“Late_In”: “10:51”,
“Early_Out”: “01:33”
}
},
“employeeDetails”: {
“mail id”: “user1@.com",
“erecno”: "1315700000234001”,
“last name”: “",
“first name”: "”,
“id”: “AI1"
}
},
{
“attendanceDetails”: {
“2024-08-26”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Janmashtami(Holiday)”,
“FirstIn_Building”: “-”,
“OverTime”: “00:00”,
“LastOut_Location”: “-”,
“ShiftName”: “General”,
“FirstIn”: “-”,
“FirstIn_Location”: “-”,
“TotalHours”: “00:00”,
“WorkingHours”: “08:00”,
“LastOut_Building”: “-”,
“LastOut”: “-”,
“ShiftEndTime”: “12:00 AM”
},
“2024-08-27”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Present”,
“FirstIn_Building”: “-”,
“OverTime”: “01:40”,
“LastOut_Location”: "”,
“ShiftName”: “General”,
“FirstIn”: “27-Aug-2024 12:40 PM”,
“FirstIn_Location”: “, *** District, Gujarat, India",
“TotalHours”: “09:40”,
“Late_In”: “12:40”,
“WorkingHours”: “08:00”,
“LastOut_Building”: “-”,
“LastOut”: “27-Aug-2024 10:20 PM”,
“Early_Out”: “01:40”,
“ShiftEndTime”: “12:00 AM”
}
},
“employeeDetails”: {
“mail id”: "user2@.com”,
“erecno”: “1315700004577269",
“last name”: "”,
“first name”: “",
“id”: "AI43”
}
}
],
“message”: “Success”,
“uri”: “/api/attendance/getUserReport”,
“status”: 0
}

If i am adding above json data in Manually Enter API Response and Save it. Then when further when i am clicking on the same then why i am showing only one employee instead of two .({
“result”: [
{
“attendanceDetails”: {
“2024-08-26”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Janmashtami(Holiday)”,
“FirstIn_Building”: “-”,
“OverTime”: “00:00”,
“LastOut_Location”: “-”,
“ShiftName”: “General”,
“FirstIn”: “-”,
“FirstIn_Location”: “-”,
“TotalHours”: “00:00”,
“WorkingHours”: “08:00”,
“LastOut_Building”: “-”,
“LastOut”: “-”,
“ShiftEndTime”: “12:00 AM”
},
“2024-08-27”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Absent”,
“FirstIn_Building”: “-”,
“LastOut_Location”: “-”,
“ShiftName”: “General”,
“FirstIn”: “-”,
“FirstIn_Location”: “-”,
“TotalHours”: “00:00”,
“WorkingHours”: “00:00”,
“LastOut_Building”: “-”,
“LastOut”: “-”,
“DeviationTime”: “08:00”,
“ShiftEndTime”: “12:00 AM”,
“OverTime”: “02:00”,
“Late_In”: “10:51”,
“Early_Out”: “01:33”
}
},
“employeeDetails”: {
“mail id”: “user1@.com",
“erecno”: "1315700000234001”,
“last name”: “",
“first name”: "”,
“id”: “AI***1”
}
}
],
“message”: “Success”,
“uri”: “/api/attendance/getUserReport”,
“status”: 0
}
)

can anyone help me why this issue is occuring?

siddharth · 2024-10-03T12:17:05.062Z

jenil.kukadiya:

If i am adding above json data in Manually Enter API Response and Save it. Then when further when i am clicking on the same then why i am showing only one employee instead of two

Because this is how it works.
Both have same json so it will have one only

jenil.kukadiya · 2024-10-03T12:38:26.590Z

So there is stored all the employees details but showing in the Manually Enter API Response only one am i right?

Jici · 2024-10-03T12:48:36.638Z

The problem is that you get a dictionnaries of data (date key) instead of an array. You will not be able to use this kind of response directly with API connector. You could consider using a third party tool, get JSON as text and use a JSON plugin, create your own plugin to transform the response or try to use this plugin:

Bubble

Templates for Bubble

Buy and sell Bubble templates to speed up app development. Bubble is a visual programing language that lets you build apps without code.

jenil.kukadiya · 2024-10-03T12:53:14.323Z

Is there any free third party tool?

Jici · 2024-10-03T12:54:22.629Z

There’s some JSON parser that are free. Regex can also be used.

jenil.kukadiya · 2024-10-03T12:56:50.146Z

can you suggest me which one is free?

system · 2024-12-12T12:01:47.494Z

This topic was automatically closed after 70 days. New replies are no longer allowed.