Discussions

Expand all | Collapse all

Using ADP Timesheet with QuickBase

  • 1.  Using ADP Timesheet with QuickBase

    Posted 05-17-2018 13:22
    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


  • 2.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 14:25
    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.


  • 3.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 15:10
    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


  • 4.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 15:12
    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.


  • 5.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 15:21
    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


  • 6.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 15:35
    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.


  • 7.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 16:02
    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.


  • 8.  RE: Using ADP Timesheet with QuickBase

    Posted 05-17-2018 16:39
    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