Issue with storing all the employees details into my DB's table

jenil.kukadiya · 2024-09-30T12:51:08.412Z

here the first workflow is used for to fetch the detials from API accoring to given URL parameters. and second workflow is used for to store all the emmployees details into my Daily attendance table.But as i have shown that in databse their is not storing employees details which was fetched from api.So can anyone help me where is actually issue?

jenil.kukadiya · 2024-09-30T13:04:42.617Z

@tunacardak

farouk.zemmouri · 2024-09-30T13:32:15.710Z

I think as second step you should schedule a workflow on a list based on a API workflow that creat your thing

jenil.kukadiya · 2024-10-01T04:35:36.230Z

How can i do that?

hanan1 · 2024-10-01T05:01:13.567Z

how does your “daily attendance” datatype look like? if it’s one (daily attendance) thing you’re creating you don’t need scheduling but if you’re storing each employee’s info as a thing then yes. Here’s how to schedule.

jenil.kukadiya · 2024-10-01T05:18:57.955Z

I’m working on a project where I need to fetch employee attendance data from an API and store it in a Daily Attendance data type. The structure of my Daily Attendance data type is shown in the image below:

image941×742 26.2 KB

The API I’m using returns data in the following format:

{
“result”: [
{
“attendanceDetails”: {
“2024-08-27”: {
“ShiftStartTime”: “12:00 AM”,
“Status”: “Present”,
“FirstIn_Building”: “-”,
“OverTime”: “02:00”,
“LastOut_Location”: “",
“ShiftName”: “General”,
“FirstIn”: “27-Aug-2024 10:51 AM”,
“FirstIn_Location”: "”,
“TotalHours”: “10:00”,
“Late_In”: “10:51”,
“WorkingHours”: “08:00”,
“LastOut_Building”: “-”,
“LastOut”: “27-Aug-2024 10:27 PM”,
“Early_Out”: “01:33”,
“ShiftEndTime”: “12:00 AM”
}
},
“employeeDetails”: {
“mail id”: “",
“erecno”: "”,
“last name”: “",
“first name”: "”,
“id”: “*****”
}
}
// More employee data here
]
}

Problem Description:

I have added two date pickers (Date A and Date B) on my page to allow users to select a start date and an end date.
After clicking the Fetch button, I want to fetch all employees’ attendance data between the selected dates using my API and store this data into my Daily Attendance table.

Currently, I’m facing two challenges:

How to store the correct date from the API data: In my current setup, I mistakenly use the current date for storing the attendance, but I need to use the specific date from the API response (e.g., 2024-08-27 for each employee’s attendance on that day).
Storing multiple employee records: I have multiple employees in the API response, and I want to create a new record for each employee in the Daily Attendance data type. The data should include details like:

Employee email
Attendance status (Present/Absent)
Total working hours
The correct date (fetched from the API response for each employee).

Here is an example of the expected behavior:

Start Date (A): 09/27/2024
End Date (B): 09/29/2024
The system should fetch the attendance details of all employees between these two dates (09/27/2024, 09/28/2024, and 09/29/2024) and store the corresponding data for each employee for each day.

Current Setup:

I have created two workflows so far:

Fetch Attendance Report:

3.Create New Daily Attendance Record:

image511×568 15.6 KB

Question:

How can I adjust my workflow to store the correct date for each employee’s attendance based on the date in the API response (rather than using the current date)?
How do I loop through the API response to create a new record for each employee and store their details in my Daily Attendance table?

Thank you for your help!

jenil.kukadiya · 2024-10-01T05:19:23.227Z

@farouk.zemmouri

jenil.kukadiya · 2024-10-01T05:19:39.363Z

@hanan1

hanan1 · 2024-10-01T07:05:38.185Z

Thanks for explaining so clearly, so you are getting all employee’s attendance records as a list; in this case you should schedule an API workflow on a list (the API response) to create a new Daily Attendance for each record. Check the link I shared earlier

hanan1:

Here’s how to schedule.

to learn how to do it. I also wrote a blogpost tutorial that includes this case, skip to recursive workflows to find this case. If you need coaching, I’m happy to help. let me know.

jenil.kukadiya · 2024-10-01T07:08:03.267Z

can i do it with my Free plan?

jenil.kukadiya · 2024-10-01T07:08:37.699Z

@hanan1

system · 2024-12-09T12:51:36.481Z

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