Using ADP Timesheet with QuickBase

QB has a very extensive API that allows you to integrate with outside systems.  You can reference the API here: https://help.quickbase.com/api-guide/index.html

You will need to determine the API options that ADP has.  Compare those with your business requirements and put together a plan that some developers can work with.

I have done work with ADP and what I have found that the Payroll admin actually wants is a properly formatted csv file to import into ADP.  They then get 95% of the data imported correctly and use the native ADP interface to maker any final changes before they "transmit".

ie the ADP system I have seen allow a holding area for the data to be transmitted where the data can be edited, before the official "transmit

Thanks for the quick replies.

However, I may have not stated my problem clearly enough. 

You stated, "just a carefully constructed CSV manually file **exported from Quick** Base by running a report and save as spreadsheet."

What I am trying to do is import timesheets FROM ADP into a QuickBase table. If so, I am trying to figure out the procedure for a formula URL to:

1. Successfully handle authentication (How is this done? Documentation only provides a rough idea)
2. Use a GET request on a specified timesheet to import

-John

That information would need to come from people who understand the availability of APIs for accessing ADP data.  Maybe there is a Community forum for ADP somewhere.

At the very least, what API calls might I be working with on QuickBase's end to access a remote website?

I am trying to grasp the procedure but have never worked with an API before.

If you use the ? at the top of any Quick Base page it takes you to HELP.   Search on API and limit to On Line help and among other hits you will get this one which is a list of all the APIs with examples of how to use them

https://help.quickbase.com/user-assistance/apicalls.html