API Access

The eFAACT Customer API provides secure external access to designated areas of your eFAACT database and requires an api key. Submit an eF HelpDesk request to receive your company specific api_key. This key is similar to a password and should be kept confidential.

To activate your api_key, entered the key in eFAACT Company Settings under “api_key”. To deactivate (stopping access to your data via the api) remove the key from Company Settings.

The following table shows views currently available to customers. Additional API views may be requested via the eFAACT Helpdesk, if doing so please provide detailed data specifications.

Each API call currently requires passing a StartDate and EndDate.

VIEW NAME	DESCRIPTION
Timedetail	This view is focused on time detail and contains detailed daily time entries for employee and consultant timecard activity entered during the provided date range.
Labordetail	This view focuses on labor detail and contains daily records for all employee and consultant time activity that has been processed by eFAACT during the provided date range. Labor detail differs from time detail in that it includes incurred costs and invoice amounts with burdens.
Fundingstatus	This view focuses on the status of contract funding and delivers the status of contract funding as of the provided end date. Funding details include a monthly burn rate for both hours and dollars, similar to eFAACT report 301.
Serviceitemhistory	This view delivers the history for service items in effect during period processing. History includes service item price and cost for the provided date range, similar to the History section of the Service Item page.
Userlist	This view delivers select user information as displayed on the All Users page.
Taskmanagerlist	This view returns a list of task managers with their assigned tasks.
Employeeleave	This view focuses on employee leave both accrued and taken for the provided date range, similar to the Manage Leave History section of Leave Accruals page.
Payrollexport	This view delivers payroll data for the selected date range. The payroll data is presented in the format setup for the eFAACT third party payroll export. Adjustments to the payroll export format will be reflected in this view as well.
EmployeeLeaveRequest	This view delivers leave request submitted for the requested date range.

eFAACT Customer API Introduction Video for steps

Update the "INSERT COMPANY API KEY" with your company specific API key then paste the following into the fx (function) bar.

The highlighted text (beginning with the ?) varies for each type of api call. For additional views, submit an eFAACT HelpDesk ticket outlining your requirements.

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=labordetail&Startdate=2021-01-01&Enddate=2021-01-31",[Headers=[api_key="INSERT COMPANY API KEY"]]))

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=fundingstatus&Startdate=2021-01-01&Enddate=2021-01-31",[Headers=[api_key="INSERT COMPANY API KEY"]]))

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=timedetail&Startdate=2021-01-01&Enddate=2021-01-31",[Headers=[api_key="INSERT COMPANY API KEY"]]))

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=employeeleave&Startdate=2022-07-01&Enddate=2022-07-31",[Headers=[api_key="INSERT COMPANY API KEY"]]))

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=serviceitemhistory&Startdate=2022-07-01&Enddate=2022-07-31,[Headers=[api_key="INSERT COMPANY API KEY"]]))

= Json.Document(Web.Contents("https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=userlist&Startdate=2021-01-01&Enddate=2021-01-31",[Headers=[api_key=" INSERT COMPANY API KEY"]]))

=Json.Document(Web.Contents(“https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=taskmanagerlist&Startdate=2021-01-01&Enddate=2021-01-31”,[Headers=[api_key=”<INSERT COMPANY API KEY>"]]))

=Json.Document(Web.Contents(“https://mvcservices.efaactcentral.com/efaactcentral/api/Customerapi?Viewname=employeeleaverequest&Startdate=2021-01-01&Enddate=2021-01-31”,[Headers=[api_key=”<INSERT COMPANY API KEY>"]]))

Or review the eFAACT API Sample Code Snippets

API Access

Timedetail

This view is focused on time detail and contains detailed daily time entries for employee and consultant timecard activity entered during the provided date range.

Labordetail

This view focuses on labor detail and contains daily records for all employee and consultant time activity that has been processed by eFAACT during the provided date range. Labor detail differs from time detail in that it includes incurred costs and invoice amounts with burdens.

Fundingstatus

This view focuses on the status of contract funding and delivers the status of contract funding as of the provided end date. Funding details include a monthly burn rate for both hours and dollars, similar to eFAACT report 301.

Serviceitemhistory

This view delivers the history for service items in effect during period processing. History includes service item price and cost for the provided date range, similar to the History section of the Service Item page.

Userlist

This view delivers select user information as displayed on the All Users page.

Taskmanagerlist

This view returns a list of task managers with their assigned tasks.

Employeeleave

This view focuses on employee leave both accrued and taken for the provided date range, similar to the Manage Leave History section of Leave Accruals page.

This view delivers leave request submitted for the requested date range.