Excel Add-In for ADP

Build 24.0.9060

WorkersPhotos

Returns workers photos.

Table Specific Information

Select

The add-in uses the ADP API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

  • AssociateOID supports the '=' comparison.
  • WorkerID supports the '=' comparison.
  • AsOfDate supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM WorkersPhotos WHERE AssociateOID = 'G3349PZGBADQY8H7'

SELECT * FROM WorkersPhotos WHERE WorkerID = 'DRH9M9NPW'

SELECT * FROM WorkersPhotos WHERE AsOfDate = '2020-01-01'

Columns

Name Type References Description
AssociateOID String

Workers.AssociateOID

WorkerID String

Workers.WorkerID

ItemID String
Links String
NameCode String
NameCodeLongName String
NameCodeShortName String
AsOfDate Date

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060