GET api/Employees/GetAllWhere?SqlWhereClause={SqlWhereClause}

No documentation available.
Request Information

Parameters

Name	Description	Additional information
SqlWhereClause	No documentation available.	Define this parameter in the request URI.
Response Information

Response body formats

application/json, text/json

Sample:
[
  {
    "EMPLID": "sample string 1",
    "SYSID": "sample string 2",
    "NAME": "sample string 3",
    "SSN": "sample string 4",
    "SHOPID": "sample string 5",
    "TEAMID": "sample string 6",
    "EMAIL": "sample string 7",
    "PHONE1": "sample string 8",
    "HOMEPHONE": "sample string 9",
    "CELLPHONE": "sample string 10",
    "PAGER": "sample string 11",
    "APPROVERID": "sample string 12",
    "CNTRYRES": "sample string 13",
    "SUPERVISOR": "sample string 14",
    "REGWAGE": 1.1,
    "OVTWAGE": 1.1,
    "DBTWAGE": 1.1,
    "TRVWAGE": 1.1,
    "OTTWAGE": 1.1,
    "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
    "CHGACCT1": "sample string 15",
    "CHGACCT2": "sample string 16",
    "BRANCHID": "sample string 17",
    "ACENTITYID": "sample string 18",
    "SUPEMPLID": "sample string 19",
    "EMPSKILLS": [
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "EMSIGDTL": [
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "DbFileName": "sample string 20",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  },
  {
    "EMPLID": "sample string 1",
    "SYSID": "sample string 2",
    "NAME": "sample string 3",
    "SSN": "sample string 4",
    "SHOPID": "sample string 5",
    "TEAMID": "sample string 6",
    "EMAIL": "sample string 7",
    "PHONE1": "sample string 8",
    "HOMEPHONE": "sample string 9",
    "CELLPHONE": "sample string 10",
    "PAGER": "sample string 11",
    "APPROVERID": "sample string 12",
    "CNTRYRES": "sample string 13",
    "SUPERVISOR": "sample string 14",
    "REGWAGE": 1.1,
    "OVTWAGE": 1.1,
    "DBTWAGE": 1.1,
    "TRVWAGE": 1.1,
    "OTTWAGE": 1.1,
    "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
    "CHGACCT1": "sample string 15",
    "CHGACCT2": "sample string 16",
    "BRANCHID": "sample string 17",
    "ACENTITYID": "sample string 18",
    "SUPEMPLID": "sample string 19",
    "EMPSKILLS": [
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "EMSIGDTL": [
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "DbFileName": "sample string 20",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  },
  {
    "EMPLID": "sample string 1",
    "SYSID": "sample string 2",
    "NAME": "sample string 3",
    "SSN": "sample string 4",
    "SHOPID": "sample string 5",
    "TEAMID": "sample string 6",
    "EMAIL": "sample string 7",
    "PHONE1": "sample string 8",
    "HOMEPHONE": "sample string 9",
    "CELLPHONE": "sample string 10",
    "PAGER": "sample string 11",
    "APPROVERID": "sample string 12",
    "CNTRYRES": "sample string 13",
    "SUPERVISOR": "sample string 14",
    "REGWAGE": 1.1,
    "OVTWAGE": 1.1,
    "DBTWAGE": 1.1,
    "TRVWAGE": 1.1,
    "OTTWAGE": 1.1,
    "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
    "CHGACCT1": "sample string 15",
    "CHGACCT2": "sample string 16",
    "BRANCHID": "sample string 17",
    "ACENTITYID": "sample string 18",
    "SUPEMPLID": "sample string 19",
    "EMPSKILLS": [
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "SKILLID": "sample string 2",
        "EXPIREDATE": "2025-06-06T21:07:51.3705126+00:00",
        "RANK": 1.1,
        "TIMESTMP": "2025-06-06T21:07:51.3705126+00:00",
        "DbFileName": "sample string 3",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "EMSIGDTL": [
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      },
      {
        "EMPLID": "sample string 1",
        "RECNO": 2,
        "SIGDATA": "sample string 3",
        "DbFileName": "sample string 4",
        "DbForeignKeys": [
          "sample string 1",
          "sample string 2",
          "sample string 3"
        ]
      }
    ],
    "DbFileName": "sample string 20",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  }
]
application/xml

Sample:
Sample not available.
text/xml

Sample:
Sample not available.