Using ADP Timesheet with QuickBase

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
Is it possible to use the QuickBase API with a service like ADP to import timesheets? If so, could someone please direct me as to the best way to get started on this? Any referencing material/learning material would be great!

Thanks,
John
Photo of John Barulich

John Barulich

  • 634 Points 500 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
the import format was very specific with specific column heading names, so I created mirror fields for the fields to be imported to ensure that the names matched what the ADP system expected.

So not an API access, just a carefully constructed CSV manually file exported from Quick Base by running a report and save as spreadsheet.
Photo of John Barulich

John Barulich

  • 634 Points 500 badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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.
Photo of John Barulich

John Barulich

  • 634 Points 500 badge 2x thumb
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.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
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