{"info":{"_postman_id":"33e0923d-9f0b-4976-9ecc-e78919029f46","name":"datascalehr","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"<html><head></head><body></body></html>","owner":"33756263","collectionId":"33e0923d-9f0b-4976-9ecc-e78919029f46","publishedId":"2sB2x2HtNN","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"333333","highlight":"0288d4"},"publishDate":"2025-06-26T14:43:26.000Z"},"item":[{"name":"Table","item":[{"name":"tables","item":[{"name":"{uuid}","item":[{"name":"/tables/:uuid","id":"7ee5975f-797f-4f47-ac1b-69767f6177cb","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/tables/:uuid","urlObject":{"path":["tables",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"cf71e0d5-ebed-4e3c-b650-858ad1a20753","description":{"content":"<p>(Required) The datascalehr Table UUID.This is required.</p>\n","type":"text/plain"},"type":"any","value":"cupidatat consectetur","key":"uuid"}]}},"response":[{"id":"abb1d1c9-6d02-43c3-a649-a1d9fad5c291","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tables/:uuid","host":["{{baseUrl}}"],"path":["tables",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"eiusmod velit\",\n  \"Name\": \"quis nulla exercitation esse\",\n  \"ObjectType\": \"Worker\",\n  \"TableType\": \"DatascaleToPayroll\",\n  \"Columns\": [\n    {\n      \"UUID\": \"enim veniam\",\n      \"Order\": -84571457,\n      \"OrderUI\": \"ea id nulla fugiat\",\n      \"FullName\": \"voluptate eiusmod cupidatat et\",\n      \"Name\": \"in culpa aliqua\",\n      \"_Type\": \"_String\",\n      \"Required\": false,\n      \"ColumnToColumnsRule\": {\n        \"Transformations_2\": [\n          {\n            \"Order\": 49179262,\n            \"TransformationType\": \"Replace\",\n            \"Value_1\": \"pariatur cupidatat sed proident\",\n            \"Value_2\": \"esse nostrud qui ullamco\"\n          },\n          {\n            \"Order\": -4679792,\n            \"TransformationType\": \"Multiply\",\n            \"Value_1\": \"esse qui quis sed velit\",\n            \"Value_2\": \"ipsum anim\"\n          }\n        ],\n        \"Datasources\": [\n          {\n            \"DisplayName\": \"ullamco et\"\n          },\n          {\n            \"DisplayName\": \"sint eu mollit\"\n          }\n        ]\n      }\n    },\n    {\n      \"UUID\": \"elit\",\n      \"Order\": -92761751,\n      \"OrderUI\": \"in do\",\n      \"FullName\": \"quis irure veniam sunt\",\n      \"Name\": \"culpa\",\n      \"_Type\": \"_Money\",\n      \"Required\": false,\n      \"ColumnToColumnsRule\": {\n        \"Transformations_2\": [\n          {\n            \"Order\": 90557655,\n            \"TransformationType\": \"Multiply\",\n            \"Value_1\": \"sunt aute\",\n            \"Value_2\": \"in id\"\n          },\n          {\n            \"Order\": 30938063,\n            \"TransformationType\": \"Concatenation\",\n            \"Value_1\": \"qui nulla\",\n            \"Value_2\": \"in nulla ea est\"\n          }\n        ],\n        \"Datasources\": [\n          {\n            \"DisplayName\": \"in pariatur sunt\"\n          },\n          {\n            \"DisplayName\": \"ullamco anim do\"\n          }\n        ]\n      }\n    }\n  ],\n  \"PayrollEntity\": {\n    \"UUID\": \"do proident in\",\n    \"Name\": \"quis nulla proident\",\n    \"Client\": {\n      \"UUID\": \"fugiat culpa mollit\",\n      \"Name\": \"sit qui\"\n    }\n  },\n  \"Template\": {\n    \"UUID\": \"minim consequat\",\n    \"Name\": \"eu in sunt\"\n  }\n}"},{"id":"a44cdbb0-039f-4e44-b7ac-75b63ae3a54d","name":"Authentication information is missing or invalid","originalRequest":{"method":"GET","header":[{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tables/:uuid","host":["{{baseUrl}}"],"path":["tables",":uuid"],"variable":[{"key":"uuid"}]}},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"cupidatat consectetur"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"7ee5975f-797f-4f47-ac1b-69767f6177cb"}],"id":"d4fe751d-be62-44e2-862d-1e11c6bc81e9","_postman_id":"d4fe751d-be62-44e2-862d-1e11c6bc81e9","description":""},{"name":"/tables","id":"ab4e30eb-2918-42c7-8d2a-cb0420476e7d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/tables?client=cupidatat consectetur&payrollEntity=cupidatat consectetur&tableType=DatascaleToBank&page=67965195&pageSize=67965195&template=cupidatat consectetur&table=cupidatat consectetur","urlObject":{"path":["tables"],"host":["{{baseUrl}}"],"query":[{"description":{"content":"<p>The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"client","value":"cupidatat consectetur"},{"description":{"content":"<p>The datascalehr Payroll Entity UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"payrollEntity","value":"cupidatat consectetur"},{"description":{"content":"<p>The TableType. Please refer to API documentation for available values of TableType. TableType is useful to filter out Client / Export / Payroll Results / Recurring Reports. This is optional.</p>\n","type":"text/plain"},"key":"tableType","value":"DatascaleToBank"},{"description":{"content":"<p>Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tables, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.</p>\n","type":"text/plain"},"key":"page","value":"67965195"},{"description":{"content":"<p>This parameter is optional. If left blank, it defaults to 10.</p>\n","type":"text/plain"},"key":"pageSize","value":"67965195"},{"description":{"content":"<p>The datascalehr Template UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"template","value":"cupidatat consectetur"},{"description":{"content":"<p>The datascalehr Table UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"table","value":"cupidatat consectetur"}],"variable":[]}},"response":[{"id":"fc86cb20-e209-4349-829c-7c5311850174","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tables?client=cupidatat consectetur&payrollEntity=cupidatat consectetur&tableType=DatascaleToBank&page=67965195&pageSize=67965195&template=cupidatat consectetur&table=cupidatat consectetur","host":["{{baseUrl}}"],"path":["tables"],"query":[{"description":"The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.","key":"client","value":"cupidatat consectetur"},{"description":"The datascalehr Payroll Entity UUID or name. Note that name is case sensitive.This parameter is optional.","key":"payrollEntity","value":"cupidatat consectetur"},{"description":"The TableType. Please refer to API documentation for available values of TableType. TableType is useful to filter out Client / Export / Payroll Results / Recurring Reports. This is optional.","key":"tableType","value":"DatascaleToBank"},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tables, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.","key":"page","value":"67965195"},{"description":"This parameter is optional. If left blank, it defaults to 10.","key":"pageSize","value":"67965195"},{"description":"The datascalehr Template UUID or name. Note that name is case sensitive.This parameter is optional.","key":"template","value":"cupidatat consectetur"},{"description":"The datascalehr Table UUID or name. Note that name is case sensitive.This parameter is optional.","key":"table","value":"cupidatat consectetur"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"[\n  {\n    \"UUID\": \"sed ipsum dolor ad\",\n    \"Name\": \"in eiusmod\",\n    \"ObjectType\": \"PayCode\",\n    \"TableType\": \"ClientToDatascale\",\n    \"PayrollEntity\": {\n      \"UUID\": \"elit ipsum aliquip\",\n      \"Name\": \"nostrud Duis amet\",\n      \"Client\": {\n        \"UUID\": \"eu in\",\n        \"Name\": \"adipisicing esse\"\n      }\n    },\n    \"Template\": {\n      \"UUID\": \"ad occaecat\",\n      \"Name\": \"consequat sint in\"\n    }\n  },\n  {\n    \"UUID\": \"deserunt enim irure ipsum\",\n    \"Name\": \"ea velit elit ex et\",\n    \"ObjectType\": \"Worker\",\n    \"TableType\": \"DatascaleToPayroll\",\n    \"PayrollEntity\": {\n      \"UUID\": \"aliqua exercitation\",\n      \"Name\": \"nisi consequat ea fugiat\",\n      \"Client\": {\n        \"UUID\": \"enim dolor nulla\",\n        \"Name\": \"Lorem\"\n      }\n    },\n    \"Template\": {\n      \"UUID\": \"sunt voluptate\",\n      \"Name\": \"occaecat magna\"\n    }\n  }\n]"},{"id":"2d8cb416-93a7-4e2b-b7ea-f7442a1e0b50","name":"Authentication information is missing or invalid","originalRequest":{"method":"GET","header":[{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tables?client=cupidatat consectetur&payrollEntity=cupidatat consectetur&tableType=DatascaleToBank&page=67965195&pageSize=67965195&template=cupidatat consectetur&table=cupidatat consectetur","host":["{{baseUrl}}"],"path":["tables"],"query":[{"description":"The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.","key":"client","value":"cupidatat consectetur"},{"description":"The datascalehr Payroll Entity UUID or name. Note that name is case sensitive.This parameter is optional.","key":"payrollEntity","value":"cupidatat consectetur"},{"description":"The TableType. Please refer to API documentation for available values of TableType. TableType is useful to filter out Client / Export / Payroll Results / Recurring Reports. This is optional.","key":"tableType","value":"DatascaleToBank"},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tables, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.","key":"page","value":"67965195"},{"description":"This parameter is optional. If left blank, it defaults to 10.","key":"pageSize","value":"67965195"},{"description":"The datascalehr Template UUID or name. Note that name is case sensitive.This parameter is optional.","key":"template","value":"cupidatat consectetur"},{"description":"The datascalehr Table UUID or name. Note that name is case sensitive.This parameter is optional.","key":"table","value":"cupidatat consectetur"}]}},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"cupidatat consectetur"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"ab4e30eb-2918-42c7-8d2a-cb0420476e7d"}],"id":"24d33006-c6e8-4b4a-a346-10d7f2605a38","_postman_id":"24d33006-c6e8-4b4a-a346-10d7f2605a38","description":""},{"name":"data","item":[{"name":"search","item":[{"name":"Retrieve data from provided table.","id":"ab187bb7-1570-47f9-985b-a2c5c94160c1","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/octet-stream"}],"body":{"mode":"raw","raw":"{\n  \"Table\": \"ut ut deserunt\",\n  \"Client\": \"in id veniam\",\n  \"PayrollEntity\": \"consequat\",\n  \"Fields\": [\n    {\n      \"Name\": \"sed incididunt fugiat\",\n      \"DisplayName\": \"nulla\"\n    },\n    {\n      \"Name\": \"esse quis minim voluptate\",\n      \"DisplayName\": \"qui Ut labore ad id\"\n    }\n  ],\n  \"Payrun\": \"in\",\n  \"AggregationInfo\": {\n    \"AggregationType\": \"RECENT\"\n  },\n  \"Keys\": [\n    {\n      \"DisplayName\": \"ad est irure Ut adipisicing\",\n      \"SystemName\": \"DSHR_PAYROLLENTITY_UUID\"\n    },\n    {\n      \"DisplayName\": \"sit magna\",\n      \"SystemName\": \"DSHR_WORKER_UUID\"\n    }\n  ],\n  \"FilterInfo\": {\n    \"FilterType\": \"Objects\",\n    \"SetUUID\": \"minim\",\n    \"Workers\": [\n      {\n        \"UUID\": \"dolore occaeca\"\n      },\n      {\n        \"UUID\": \"id elit et\"\n      }\n    ]\n  }\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/data/search","description":"<p>This API returns an optimizied excel stream.<br />It can be used to fetch data in master tables , transactional tables and payrun related tables.<br />For payrun related tables , payrun must be provided.</p>\n","urlObject":{"path":["data","search"],"host":["{{baseUrl}}"],"query":[],"variable":[]}},"response":[{"id":"088dab37-e0a6-4782-b42d-b43ec360a944","name":"successful operation","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/octet-stream"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"body":{"mode":"raw","raw":"{\n  \"Table\": \"ut ut deserunt\",\n  \"Client\": \"in id veniam\",\n  \"PayrollEntity\": \"consequat\",\n  \"Fields\": [\n    {\n      \"Name\": \"sed incididunt fugiat\",\n      \"DisplayName\": \"nulla\"\n    },\n    {\n      \"Name\": \"esse quis minim voluptate\",\n      \"DisplayName\": \"qui Ut labore ad id\"\n    }\n  ],\n  \"Payrun\": \"in\",\n  \"AggregationInfo\": {\n    \"AggregationType\": \"RECENT\"\n  },\n  \"Keys\": [\n    {\n      \"DisplayName\": \"ad est irure Ut adipisicing\",\n      \"SystemName\": \"DSHR_PAYROLLENTITY_UUID\"\n    },\n    {\n      \"DisplayName\": \"sit magna\",\n      \"SystemName\": \"DSHR_WORKER_UUID\"\n    }\n  ],\n  \"FilterInfo\": {\n    \"FilterType\": \"Objects\",\n    \"SetUUID\": \"minim\",\n    \"Workers\": [\n      {\n        \"UUID\": \"dolore occaeca\"\n      },\n      {\n        \"UUID\": \"id elit et\"\n      }\n    ]\n  }\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/data/search"},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[{"key":"Content-Type","value":"application/octet-stream"}],"cookie":[],"responseTime":null,"body":"sint"},{"id":"8fbfd7a2-605b-46c9-be49-5bca72354b8d","name":"Authentication information is missing or invalid","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"body":{"mode":"raw","raw":"{\n  \"Table\": \"ut ut deserunt\",\n  \"Client\": \"in id veniam\",\n  \"PayrollEntity\": \"consequat\",\n  \"Fields\": [\n    {\n      \"Name\": \"sed incididunt fugiat\",\n      \"DisplayName\": \"nulla\"\n    },\n    {\n      \"Name\": \"esse quis minim voluptate\",\n      \"DisplayName\": \"qui Ut labore ad id\"\n    }\n  ],\n  \"Payrun\": \"in\",\n  \"AggregationInfo\": {\n    \"AggregationType\": \"RECENT\"\n  },\n  \"Keys\": [\n    {\n      \"DisplayName\": \"ad est irure Ut adipisicing\",\n      \"SystemName\": \"DSHR_PAYROLLENTITY_UUID\"\n    },\n    {\n      \"DisplayName\": \"sit magna\",\n      \"SystemName\": \"DSHR_WORKER_UUID\"\n    }\n  ],\n  \"FilterInfo\": {\n    \"FilterType\": \"Objects\",\n    \"SetUUID\": \"minim\",\n    \"Workers\": [\n      {\n        \"UUID\": \"dolore occaeca\"\n      },\n      {\n        \"UUID\": \"id elit et\"\n      }\n    ]\n  }\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/data/search"},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"cupidatat consectetur"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"ab187bb7-1570-47f9-985b-a2c5c94160c1"}],"id":"e5c29adb-f7a5-4b15-889b-554154be4e17","_postman_id":"e5c29adb-f7a5-4b15-889b-554154be4e17","description":""}],"id":"c962294f-a77d-4adc-963b-6b50c6f8c9d6","_postman_id":"c962294f-a77d-4adc-963b-6b50c6f8c9d6","description":""},{"name":"transaction","item":[{"name":"upload","item":[{"name":"Upload data","id":"fcfad6c1-1d47-407a-89b3-a0af1baf912d","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"multipart/form-data"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"formdata","formdata":[{"description":"<p>This is the file to be uploaded. This is required.</p>\n","key":"File","type":"file","value":null},{"description":"<p>The datascalehr Table UUID. This identifies the table into which data must be uploaded. This is required.</p>\n","key":"TableUUID","value":"elit labor","type":"text"},{"description":"<p>The datascalehr Payrun UUID. This is required for payrun related tables. It identifies the payrun for which the data is uploaded. Example - If payroll results are being uploaded, we need the payrun for which the data is to be uploaded.</p>\n","key":"PayrunUUID","value":"consequat amet do dolore","type":"text"},{"description":"<p>The filename. Example results15.xlsx. Please ensure that you have the file extension as shown in the example. This is required.</p>\n","key":"FileName","value":"sit proident aute Duis elit","type":"text"}]},"url":"{{baseUrl}}/transaction/upload","urlObject":{"path":["transaction","upload"],"host":["{{baseUrl}}"],"query":[],"variable":[]}},"response":[{"id":"1ae550b0-a76a-409a-b71e-1a3ca63ea390","name":"successful operation","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"multipart/form-data"},{"key":"Accept","value":"application/xml"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"body":{"mode":"formdata","formdata":[{"description":"This is the file to be uploaded. This is required.","key":"File","type":"file","src":[]},{"description":"The datascalehr Table UUID. This identifies the table into which data must be uploaded. This is required.","key":"TableUUID","value":"elit labor","type":"text"},{"description":"The datascalehr Payrun UUID. This is required for payrun related tables. It identifies the payrun for which the data is uploaded. Example - If payroll results are being uploaded, we need the payrun for which the data is to be uploaded.","key":"PayrunUUID","value":"consequat amet do dolore","type":"text"},{"description":"The filename. Example results15.xlsx. Please ensure that you have the file extension as shown in the example. This is required.","key":"FileName","value":"sit proident aute Duis elit","type":"text"}]},"url":"{{baseUrl}}/transaction/upload"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"dolore amet\",\n  \"TransactionStatus\": \"Pending\",\n  \"StartDateTime\": \"1956-06-14T17:23:20.093Z\",\n  \"EndDateTime\": \"2016-02-17T10:48:13.961Z\",\n  \"InitiatedByDisplayName\": \"id\",\n  \"AssignedToDisplayName\": \"el\",\n  \"TransactionType\": \"ReconciliationRuleChange\"\n}"},{"id":"68f4f75b-fec7-4091-9a2a-93a26caf14ed","name":"Authentication information is missing or invalid","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"multipart/form-data"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"body":{"mode":"formdata","formdata":[{"description":"This is the file to be uploaded. This is required.","key":"File","type":"file","src":[]},{"description":"The datascalehr Table UUID. This identifies the table into which data must be uploaded. This is required.","key":"TableUUID","value":"elit labor","type":"text"},{"description":"The datascalehr Payrun UUID. This is required for payrun related tables. It identifies the payrun for which the data is uploaded. Example - If payroll results are being uploaded, we need the payrun for which the data is to be uploaded.","key":"PayrunUUID","value":"consequat amet do dolore","type":"text"},{"description":"The filename. Example results15.xlsx. Please ensure that you have the file extension as shown in the example. This is required.","key":"FileName","value":"sit proident aute Duis elit","type":"text"}]},"url":"{{baseUrl}}/transaction/upload"},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"cupidatat consectetur"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"fcfad6c1-1d47-407a-89b3-a0af1baf912d"}],"id":"7963aca0-8d91-4e11-9341-7e8a289fe898","_postman_id":"7963aca0-8d91-4e11-9341-7e8a289fe898","description":""}],"id":"2c908833-f8ba-4107-a571-2cc4e5537b72","_postman_id":"2c908833-f8ba-4107-a571-2cc4e5537b72","description":""}],"id":"272709f3-acf7-4e27-82c0-8a0c89085a96","description":"<h1 id=\"complete-table-management-and-data-operations\">Complete Table Management and Data Operations</h1>\n<h2 id=\"table-management\">Table Management</h2>\n<h3 id=\"list-tables-with-filtering-by\">List tables with filtering by:</h3>\n<ul>\n<li><p>Client and payroll entity</p>\n</li>\n<li><p>Table type (Client to datascalehr, datascalehr to Payroll, etc.)</p>\n</li>\n<li><p>Template associations</p>\n</li>\n</ul>\n<h3 id=\"retrieve-detailed-table-metadata-including\">Retrieve detailed table metadata including:</h3>\n<ul>\n<li><p>Column definitions and data types</p>\n</li>\n<li><p>Transformation rules</p>\n</li>\n<li><p>Required field validations</p>\n</li>\n</ul>\n<h2 id=\"data-operations\">Data Operations</h2>\n<h3 id=\"search-and-export-table-data-with\">Search and export table data with:</h3>\n<ul>\n<li><p>Custom field selection and aliasing</p>\n</li>\n<li><p>Aggregation functions: <code>SUM</code>, <code>MIN</code>, <code>MAX</code>, <code>AVG</code>, <code>EARLIEST</code>, <code>RECENT</code></p>\n</li>\n<li><p>Worker-level filtering</p>\n</li>\n<li><p>System key inclusion (Worker UUID, Client UUID, etc.)</p>\n</li>\n</ul>\n<h3 id=\"upload-files-to-tables\">Upload files to tables:</h3>\n<ul>\n<li><p>Multipart form data support</p>\n</li>\n<li><p>Payrun-specific uploads</p>\n</li>\n<li><p>Transaction tracking for uploads</p>\n</li>\n</ul>\n","_postman_id":"272709f3-acf7-4e27-82c0-8a0c89085a96"},{"name":"Ticket","item":[{"name":"tickets","item":[{"name":"Retrieve payrun related tickets","id":"fd921e87-c753-4029-b3d9-e4c12bb2d852","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/tickets?status=Closed&severity=Error&client=nulla id ut labore quis&payrollEntity=nulla id ut labore quis&payrun=nulla id ut labore quis&fromDateTime=1954-01-16T06:42:16.947Z&toDateTime=1954-01-16T06:42:16.947Z&page=-76989290&pageSize=-76989290&transactionUUID=nulla id ut labore quis","description":"<p>This API gets payrun related tickets. It offers flexibility with multiple parameters. If all parameters are left empty , it gets the first 100 tickets that the user has access to.</p>\n","urlObject":{"path":["tickets"],"host":["{{baseUrl}}"],"query":[{"key":"status","value":"Closed"},{"key":"severity","value":"Error"},{"description":{"content":"<p>The datascalehr client UUID or name.</p>\n","type":"text/plain"},"key":"client","value":"nulla id ut labore quis"},{"description":{"content":"<p>The datascalehr UUID or Name of the Payroll Entity. Note that Name is case sensitive.</p>\n","type":"text/plain"},"key":"payrollEntity","value":"nulla id ut labore quis"},{"description":{"content":"<p>The datascalehr UUID or User provided ID (e.g. Apr 2024) of the Payrun </p>\n","type":"text/plain"},"key":"payrun","value":"nulla id ut labore quis"},{"description":{"content":"<p>Fetch tickets that were created or changed between fromDateTime &amp; toDateTime. \nExample : 2024-03-26 for just date ,  2024-03-26T18:00:00 for date and time</p>\n","type":"text/plain"},"key":"fromDateTime","value":"1954-01-16T06:42:16.947Z"},{"key":"toDateTime","value":"1954-01-16T06:42:16.947Z"},{"description":{"content":"<p>Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tickets , use page = 0 and pageSize = 50</p>\n","type":"text/plain"},"key":"page","value":"-76989290"},{"description":{"content":"<p>Default pageSize is 10</p>\n","type":"text/plain"},"key":"pageSize","value":"-76989290"},{"key":"transactionUUID","value":"nulla id ut labore quis"}],"variable":[]}},"response":[{"id":"a916a013-e010-453f-a529-3a584a122b8c","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tickets?status=Closed&severity=Error&client=nulla id ut labore quis&payrollEntity=nulla id ut labore quis&payrun=nulla id ut labore quis&fromDateTime=1954-01-16T06:42:16.947Z&toDateTime=1954-01-16T06:42:16.947Z&page=-76989290&pageSize=-76989290&transactionUUID=nulla id ut labore quis","host":["{{baseUrl}}"],"path":["tickets"],"query":[{"key":"status","value":"Closed"},{"key":"severity","value":"Error"},{"description":"The datascalehr client UUID or name.","key":"client","value":"nulla id ut labore quis"},{"description":"The datascalehr UUID or Name of the Payroll Entity. Note that Name is case sensitive.","key":"payrollEntity","value":"nulla id ut labore quis"},{"description":"The datascalehr UUID or User provided ID (e.g. Apr 2024) of the Payrun ","key":"payrun","value":"nulla id ut labore quis"},{"description":"Fetch tickets that were created or changed between fromDateTime & toDateTime. \r\nExample : 2024-03-26 for just date ,  2024-03-26T18:00:00 for date and time","key":"fromDateTime","value":"1954-01-16T06:42:16.947Z"},{"key":"toDateTime","value":"1954-01-16T06:42:16.947Z"},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tickets , use page = 0 and pageSize = 50","key":"page","value":"-76989290"},{"description":"Default pageSize is 10","key":"pageSize","value":"-76989290"},{"key":"transactionUUID","value":"nulla id ut labore quis"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"[\n  {\n    \"Summary\": \"veniam fugiat\",\n    \"Description\": \"non dolore\",\n    \"Status\": \"Open\",\n    \"Severity\": \"Information\",\n    \"Category\": \"Paycode\",\n    \"SubCategoryForWorker\": \"In_payroll_results_but_inactive\",\n    \"SubCategoryForValue\": \"Validation\",\n    \"SubCategoryForColumn\": \"BlankValueAccept\",\n    \"SubCategoryForWorkerItem\": \"WorkerName_PartialMatch\",\n    \"ReconciliationValue\": \"laboris adipisici\",\n    \"PayrollEntityUUID\": \"esse sit ut\",\n    \"PayrollEntityName\": \"quis ut mollit irure\",\n    \"PayrunUUID\": \"mollit minim dolor fugiat\",\n    \"PayrunID\": \"ut esse do\",\n    \"WorkerUUID\": \"ea qui amet\",\n    \"WorkerID\": \"in cillum officia aute\",\n    \"CreatedDateTime\": \"1995-06-23T16:57:23.120Z\",\n    \"ChangedDateTime\": \"1981-12-09T01:43:56.356Z\",\n    \"Type\": \"Payrun\",\n    \"FieldValueInfo\": {\n      \"Field\": \"tempor ut non proident\",\n      \"Value\": \"deserunt consequat\",\n      \"ExpectedValue\": \"aliqua mollit sed ut\"\n    },\n    \"ClientUUID\": \"enim nostru\",\n    \"ClientName\": \"incididunt cillum ullamco\"\n  },\n  {\n    \"Summary\": \"veniam in elit\",\n    \"Description\": \"Lorem id labore tempor sunt\",\n    \"Status\": \"Closed\",\n    \"Severity\": \"Warning\",\n    \"Category\": \"Column\",\n    \"SubCategoryForWorker\": \"Not_in_payroll_results\",\n    \"SubCategoryForValue\": \"Reconciliation\",\n    \"SubCategoryForColumn\": \"BlankValueIgnore\",\n    \"SubCategoryForWorkerItem\": \"WorkerName_PartialMatch\",\n    \"ReconciliationValue\": \"proident ut et\",\n    \"PayrollEntityUUID\": \"Lorem in commodo ut incididunt\",\n    \"PayrollEntityName\": \"officia elit do dolore\",\n    \"PayrunUUID\": \"commodo dolore\",\n    \"PayrunID\": \"Lorem dolore Ut laboris\",\n    \"WorkerUUID\": \"magna culpa pro\",\n    \"WorkerID\": \"adipisicing proident occaecat eiusmod esse\",\n    \"CreatedDateTime\": \"1980-03-14T15:27:36.752Z\",\n    \"ChangedDateTime\": \"2015-08-02T06:55:33.303Z\",\n    \"Type\": \"ReversePropagation\",\n    \"FieldValueInfo\": {\n      \"Field\": \"dolore ipsum \",\n      \"Value\": \"elit Duis\",\n      \"ExpectedValue\": \"ipsum id tempor\"\n    },\n    \"ClientUUID\": \"Ut esse\",\n    \"ClientName\": \"Excepteur magna consequat in\"\n  }\n]"},{"id":"1f9845b4-8cfe-4129-8b17-220a68773384","name":"Authentication information is missing or invalid","originalRequest":{"method":"GET","header":[{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/tickets?status=Closed&severity=Error&client=nulla id ut labore quis&payrollEntity=nulla id ut labore quis&payrun=nulla id ut labore quis&fromDateTime=1954-01-16T06:42:16.947Z&toDateTime=1954-01-16T06:42:16.947Z&page=-76989290&pageSize=-76989290&transactionUUID=nulla id ut labore quis","host":["{{baseUrl}}"],"path":["tickets"],"query":[{"key":"status","value":"Closed"},{"key":"severity","value":"Error"},{"description":"The datascalehr client UUID or name.","key":"client","value":"nulla id ut labore quis"},{"description":"The datascalehr UUID or Name of the Payroll Entity. Note that Name is case sensitive.","key":"payrollEntity","value":"nulla id ut labore quis"},{"description":"The datascalehr UUID or User provided ID (e.g. Apr 2024) of the Payrun ","key":"payrun","value":"nulla id ut labore quis"},{"description":"Fetch tickets that were created or changed between fromDateTime & toDateTime. \r\nExample : 2024-03-26 for just date ,  2024-03-26T18:00:00 for date and time","key":"fromDateTime","value":"1954-01-16T06:42:16.947Z"},{"key":"toDateTime","value":"1954-01-16T06:42:16.947Z"},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 tickets , use page = 0 and pageSize = 50","key":"page","value":"-76989290"},{"description":"Default pageSize is 10","key":"pageSize","value":"-76989290"},{"key":"transactionUUID","value":"nulla id ut labore quis"}]}},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"nulla id ut labore quis"}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"fd921e87-c753-4029-b3d9-e4c12bb2d852"}],"id":"f02e7c3f-1a4c-443b-bc08-a582123ff03d","_postman_id":"f02e7c3f-1a4c-443b-bc08-a582123ff03d","description":""}],"id":"8daae427-3b13-45f9-a0e2-0286a5dba4b9","description":"<h1 id=\"monitor-data-quality-and-system-issues\">Monitor Data Quality and System Issues</h1>\n<h2 id=\"ticket-management\">Ticket Management</h2>\n<h3 id=\"query-tickets-with-multiple-filters\">Query Tickets with Multiple Filters:</h3>\n<ul>\n<li><p><strong>Status:</strong> Open, Closed</p>\n</li>\n<li><p><strong>Severity:</strong> Warning, Error, Information</p>\n</li>\n<li><p><strong>Client, Payroll Entity, or Payrun</strong></p>\n</li>\n<li><p><strong>Date Range:</strong> Created or Changed</p>\n</li>\n<li><p><strong>Transaction UUID</strong></p>\n</li>\n</ul>\n<h3 id=\"ticket-categories-include\">Ticket Categories Include:</h3>\n<ul>\n<li><p>Worker-related issues</p>\n</li>\n<li><p>Value validation errors</p>\n</li>\n<li><p>Reconciliation mismatches</p>\n</li>\n<li><p>Identity matching problems</p>\n</li>\n</ul>\n<h3 id=\"detailed-ticket-information\">Detailed Ticket Information:</h3>\n<ul>\n<li><p>Field-level error details</p>\n</li>\n<li><p>Expected vs. actual values</p>\n</li>\n<li><p>Associated worker information</p>\n</li>\n</ul>\n","_postman_id":"8daae427-3b13-45f9-a0e2-0286a5dba4b9"},{"name":"Payroll","item":[{"name":"payruns","item":[{"name":"Retrieve payruns","id":"691183ff-3ef7-4456-aa1f-b30f6dc23ce3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/payruns?payrollEntityUUID=in &page=10016043&pageSize=10016043&payrunEffectiveDateFrom_Included=1947-01-19T10:26:29.615Z&payrunEffectiveDateTo_Excluded=1947-01-19T10:26:29.615Z","description":"<p>The results are sorted by descending order of Payrun Effective Date.</p>\n","urlObject":{"path":["payruns"],"host":["{{baseUrl}}"],"query":[{"description":{"content":"<p>The datascalehr Payroll Entity UUID. This is optional.</p>\n","type":"text/plain"},"key":"payrollEntityUUID","value":"in "},{"description":{"content":"<p>Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 payruns, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.</p>\n","type":"text/plain"},"key":"page","value":"10016043"},{"description":{"content":"<p>Default is 10</p>\n","type":"text/plain"},"key":"pageSize","value":"10016043"},{"description":{"content":"<p>This parameter is used to filter by Effective Date. This field can be used in conjunction with the payrunEffectiveDateTo parameter to retrieve Payruns within a range.</p>\n","type":"text/plain"},"key":"payrunEffectiveDateFrom_Included","value":"1947-01-19T10:26:29.615Z"},{"key":"payrunEffectiveDateTo_Excluded","value":"1947-01-19T10:26:29.615Z"}],"variable":[]}},"response":[{"id":"b5c322ac-7408-4fb2-aad3-038df2d6becd","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"},{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/payruns?payrollEntityUUID=in &page=10016043&pageSize=10016043&payrunEffectiveDateFrom_Included=1947-01-19T10:26:29.615Z&payrunEffectiveDateTo_Excluded=1947-01-19T10:26:29.615Z","host":["{{baseUrl}}"],"path":["payruns"],"query":[{"description":"The datascalehr Payroll Entity UUID. This is optional.","key":"payrollEntityUUID","value":"in "},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 payruns, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.","key":"page","value":"10016043"},{"description":"Default is 10","key":"pageSize","value":"10016043"},{"description":"This parameter is used to filter by Effective Date. This field can be used in conjunction with the payrunEffectiveDateTo parameter to retrieve Payruns within a range.","key":"payrunEffectiveDateFrom_Included","value":"1947-01-19T10:26:29.615Z"},{"key":"payrunEffectiveDateTo_Excluded","value":"1947-01-19T10:26:29.615Z"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"[\n  {\n    \"Status\": \"Resetting\",\n    \"PeriodStartDate\": \"1961-11-03T18:06:06.352Z\",\n    \"PeriodEndDate\": \"1972-01-28T20:10:54.866Z\",\n    \"YearMonth\": \"proident\",\n    \"UUID\": \"in nisi\",\n    \"ObjectID\": \"commodo ut\",\n    \"EffectiveDate\": \"1999-10-22T07:04:23.170Z\",\n    \"PayrollEntity\": {\n      \"UUID\": \"ir\",\n      \"Name\": \"id officia ex proident laborum\"\n    }\n  },\n  {\n    \"Status\": \"Locked\",\n    \"PeriodStartDate\": \"1969-10-08T22:49:48.115Z\",\n    \"PeriodEndDate\": \"1950-11-17T15:06:51.667Z\",\n    \"YearMonth\": \"Ut non eu id\",\n    \"UUID\": \"labore adipisicing\",\n    \"ObjectID\": \"laborum est\",\n    \"EffectiveDate\": \"1946-03-23T09:13:19.463Z\",\n    \"PayrollEntity\": {\n      \"UUID\": \"non do nulla deserunt\",\n      \"Name\": \"minim sed esse enim\"\n    }\n  }\n]"},{"id":"2f574af4-4550-4382-b8d2-3f4fa77c92a3","name":"Authentication information is missing or invalid","originalRequest":{"method":"GET","header":[{"description":"Added as a part of security scheme: basic","key":"Authorization","value":"Basic <credentials>"}],"url":{"raw":"{{baseUrl}}/payruns?payrollEntityUUID=in &page=10016043&pageSize=10016043&payrunEffectiveDateFrom_Included=1947-01-19T10:26:29.615Z&payrunEffectiveDateTo_Excluded=1947-01-19T10:26:29.615Z","host":["{{baseUrl}}"],"path":["payruns"],"query":[{"description":"The datascalehr Payroll Entity UUID. This is optional.","key":"payrollEntityUUID","value":"in "},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 payruns, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0.","key":"page","value":"10016043"},{"description":"Default is 10","key":"pageSize","value":"10016043"},{"description":"This parameter is used to filter by Effective Date. This field can be used in conjunction with the payrunEffectiveDateTo parameter to retrieve Payruns within a range.","key":"payrunEffectiveDateFrom_Included","value":"1947-01-19T10:26:29.615Z"},{"key":"payrunEffectiveDateTo_Excluded","value":"1947-01-19T10:26:29.615Z"}]}},"status":"Unauthorized","code":401,"_postman_previewlanguage":"text","header":[{"disabled":false,"description":{"content":"","type":"text/plain"},"key":"WWW-Authenticate","value":"in "}],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"691183ff-3ef7-4456-aa1f-b30f6dc23ce3"}],"id":"deea88bd-e7ef-411c-8efd-46a55b91750a","_postman_id":"deea88bd-e7ef-411c-8efd-46a55b91750a","description":""}],"id":"0f727f7a-1b9d-4720-bc50-74cd7e340195","_postman_id":"0f727f7a-1b9d-4720-bc50-74cd7e340195","description":""},{"name":"Organization","item":[{"name":"payrollEntities","item":[{"name":"{uuid}","item":[{"name":"Retrieve Payroll Entity by UUID","id":"e1a611a0-6ef0-4365-83b2-99fc91d02983","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/payrollEntities/:uuid","description":"<p>This API retrieves Payroll Entity by UUID. </p>\n","urlObject":{"path":["payrollEntities",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"78de1bca-0531-406c-a3f1-fdf676e918ca","description":{"content":"<p>(Required) The datascalehr Payroll Entity UUID.</p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"65b536fa-594a-4c8f-bf9e-65b463efd66f","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":{"raw":"{{baseUrl}}/payrollEntities/:uuid","host":["{{baseUrl}}"],"path":["payrollEntities",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"do deserunt est incididunt\",\n  \"Name\": \"culpa veniam adi\",\n  \"Country_Letters_2\": \"Lorem minim non ad\",\n  \"FormattedAddress\": \"nisi Ut\",\n  \"Currency\": \"KZT\",\n  \"Status\": \"Active\",\n  \"Client\": {\n    \"UUID\": \"incididunt aliqua elit\",\n    \"Name\": \"dolor quis\"\n  }\n}"}],"_postman_id":"e1a611a0-6ef0-4365-83b2-99fc91d02983"},{"name":"Delete existing Payroll Entity","id":"1b573cc1-407f-4863-8b0b-c2c7d28aa308","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"{{baseUrl}}/payrollEntities/:uuid","urlObject":{"path":["payrollEntities",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"3725c241-7df4-495e-8e76-a32344885f55","description":{"content":"<p>(Required) </p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"0a010a7c-f5e8-4167-901d-d719b6e67ca1","name":"successful operation","originalRequest":{"method":"DELETE","header":[],"url":{"raw":"{{baseUrl}}/payrollEntities/:uuid","host":["{{baseUrl}}"],"path":["payrollEntities",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"1b573cc1-407f-4863-8b0b-c2c7d28aa308"},{"name":"/payrollEntities/:uuid","id":"78fd2a64-52c4-41f4-b4cb-e4ba3220478a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"in Duis magna\",\n  \"Country_Letters_2\": \"sed dolor amet\",\n  \"FormattedAddress\": \"cupidatat ullamco\",\n  \"Currency\": \"AFN\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/payrollEntities/:uuid","urlObject":{"path":["payrollEntities",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"12d1f69f-47bb-403b-8615-23408409dc90","description":{"content":"<p>(Required) </p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"2743356c-0ff3-47ce-9777-8113b94d2569","name":"successful operation","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"in Duis magna\",\n  \"Country_Letters_2\": \"sed dolor amet\",\n  \"FormattedAddress\": \"cupidatat ullamco\",\n  \"Currency\": \"AFN\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":{"raw":"{{baseUrl}}/payrollEntities/:uuid","host":["{{baseUrl}}"],"path":["payrollEntities",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"do deserunt est incididunt\",\n  \"Name\": \"culpa veniam adi\",\n  \"Country_Letters_2\": \"Lorem minim non ad\",\n  \"FormattedAddress\": \"nisi Ut\",\n  \"Currency\": \"KZT\",\n  \"Status\": \"Active\",\n  \"Client\": {\n    \"UUID\": \"incididunt aliqua elit\",\n    \"Name\": \"dolor quis\"\n  }\n}"}],"_postman_id":"78fd2a64-52c4-41f4-b4cb-e4ba3220478a"}],"id":"54336a36-f14e-4703-9a30-28ad12018f01","_postman_id":"54336a36-f14e-4703-9a30-28ad12018f01","description":""},{"name":"Retrieve Payroll Entities","id":"29553b93-0770-43a1-ad5c-2db7ad1393df","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/payrollEntities?client=labore laborum fug&payrollEntity=labore laborum fug&page=-83476782&pageSize=-83476782","description":"<p>This API retrieves Payroll Entities.<br />It offers flexibility with multiple parameters.<br />If the pagination parameters are left empty , 10 Payroll Entities are retrieved.<br />The results are sorted by name and UUID.</p>\n","urlObject":{"path":["payrollEntities"],"host":["{{baseUrl}}"],"query":[{"description":{"content":"<p>The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"client","value":"labore laborum fug"},{"description":{"content":"<p>The datascalehr Payroll Entity UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"payrollEntity","value":"labore laborum fug"},{"description":{"content":"<p>Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 entities, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0</p>\n","type":"text/plain"},"key":"page","value":"-83476782"},{"description":{"content":"<p>This parameter is optional. When left blank, it defaults to 10</p>\n","type":"text/plain"},"key":"pageSize","value":"-83476782"}],"variable":[]}},"response":[{"id":"dc0e0077-b545-4faf-bab3-dc243e38514f","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":{"raw":"{{baseUrl}}/payrollEntities?client=labore laborum fug&payrollEntity=labore laborum fug&page=-83476782&pageSize=-83476782","host":["{{baseUrl}}"],"path":["payrollEntities"],"query":[{"description":"The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.","key":"client","value":"labore laborum fug"},{"description":"The datascalehr Payroll Entity UUID or name. Note that name is case sensitive.This parameter is optional.","key":"payrollEntity","value":"labore laborum fug"},{"description":"Used in conjunction with pageSize for pagination. Starts from 0. For example , to fetch the first 50 entities, use page = 0 and pageSize = 50. This parameter is optional. If left blank, it defaults to 0","key":"page","value":"-83476782"},{"description":"This parameter is optional. When left blank, it defaults to 10","key":"pageSize","value":"-83476782"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"[\n  {\n    \"UUID\": \"in qui\",\n    \"Name\": \"commodo pariatur Duis\",\n    \"Country_Letters_2\": \"tempor cupidatat\",\n    \"FormattedAddress\": \"enim nulla magna\",\n    \"Currency\": \"EEK\",\n    \"Status\": \"Active\",\n    \"Client\": {\n      \"UUID\": \"in velit et veniam ex\",\n      \"Name\": \"aliquip\"\n    }\n  },\n  {\n    \"UUID\": \"q\",\n    \"Name\": \"el\",\n    \"Country_Letters_2\": \"id Excepteur magna exercitation\",\n    \"FormattedAddress\": \"cillum\",\n    \"Currency\": \"SVC\",\n    \"Status\": \"Deleting\",\n    \"Client\": {\n      \"UUID\": \"nostrud incididunt\",\n      \"Name\": \"ex dolor id\"\n    }\n  }\n]"}],"_postman_id":"29553b93-0770-43a1-ad5c-2db7ad1393df"},{"name":"Create a new Payroll Entity","id":"f7196397-0af5-4839-9ad7-c67e0813a853","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"nisi amet repr\",\n  \"Country_Letters_2\": \"irure est ex\",\n  \"FormattedAddress\": \"pariatur enim\",\n  \"Client\": {\n    \"UUID\": \"sed\"\n  },\n  \"Currency\": \"NADNIO\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/payrollEntities","urlObject":{"path":["payrollEntities"],"host":["{{baseUrl}}"],"query":[],"variable":[]}},"response":[{"id":"14489da6-d90a-479d-ba46-ab7c85138e74","name":"successful operation","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"nisi amet repr\",\n  \"Country_Letters_2\": \"irure est ex\",\n  \"FormattedAddress\": \"pariatur enim\",\n  \"Client\": {\n    \"UUID\": \"sed\"\n  },\n  \"Currency\": \"NADNIO\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/payrollEntities"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"do deserunt est incididunt\",\n  \"Name\": \"culpa veniam adi\",\n  \"Country_Letters_2\": \"Lorem minim non ad\",\n  \"FormattedAddress\": \"nisi Ut\",\n  \"Currency\": \"KZT\",\n  \"Status\": \"Active\",\n  \"Client\": {\n    \"UUID\": \"incididunt aliqua elit\",\n    \"Name\": \"dolor quis\"\n  }\n}"}],"_postman_id":"f7196397-0af5-4839-9ad7-c67e0813a853"}],"id":"c71ac11b-5073-494d-8a1c-602fd32d6f36","description":"<ul>\n<li><p>Query payroll entities across your organization</p>\n</li>\n<li><p>Filter by client or specific entity</p>\n</li>\n<li><p>Access entity details</p>\n</li>\n</ul>\n","_postman_id":"c71ac11b-5073-494d-8a1c-602fd32d6f36"},{"name":"clients","item":[{"name":"{uuid}","item":[{"name":"Retrieve Client by UUID","id":"4eb8ead0-0f79-4017-9964-d0cc6a3d7125","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/clients/:uuid","description":"<p>This API retrieves Client by UUID. </p>\n","urlObject":{"path":["clients",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"71620d98-2e60-4e43-bee2-0fe1983fb264","description":{"content":"<p>(Required) The datascalehr Client UUID.</p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"a75bae27-f7e3-407e-a404-f89a2217f9b0","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":{"raw":"{{baseUrl}}/clients/:uuid","host":["{{baseUrl}}"],"path":["clients",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"irure non ut laboris\",\n  \"Name\": \"officia labore ex aliqua exercitation\",\n  \"Status\": \"Active\"\n}"}],"_postman_id":"4eb8ead0-0f79-4017-9964-d0cc6a3d7125"},{"name":"Edit existing Client","id":"0e95958e-bfe9-4717-8a50-ec35ed8fbb11","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"UUID\": \"irure non ut laboris\",\n  \"Name\": \"officia labore ex aliqua exercitation\",\n  \"Status\": \"Active\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/clients/:uuid","urlObject":{"path":["clients",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"ec56336e-ab80-4e86-9201-f2cc321b4250","description":{"content":"<p>(Required) </p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"c0051640-360c-43d0-a612-8dc74abd5cdb","name":"successful operation","originalRequest":{"method":"PUT","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"UUID\": \"irure non ut laboris\",\n  \"Name\": \"officia labore ex aliqua exercitation\",\n  \"Status\": \"Active\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":{"raw":"{{baseUrl}}/clients/:uuid","host":["{{baseUrl}}"],"path":["clients",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"irure non ut laboris\",\n  \"Name\": \"officia labore ex aliqua exercitation\",\n  \"Status\": \"Active\"\n}"}],"_postman_id":"0e95958e-bfe9-4717-8a50-ec35ed8fbb11"},{"name":"Delete existing Client","id":"b9515a9f-0656-4bd2-bff6-80989bbc0530","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"DELETE","header":[],"url":"{{baseUrl}}/clients/:uuid","urlObject":{"path":["clients",":uuid"],"host":["{{baseUrl}}"],"query":[],"variable":[{"id":"e07106df-57de-4f2b-9768-d85dbc608035","description":{"content":"<p>(Required) </p>\n","type":"text/plain"},"type":"any","value":"labore laborum fug","key":"uuid"}]}},"response":[{"id":"d836f57e-aaa6-4d38-aa65-9f941290f1ad","name":"successful operation","originalRequest":{"method":"DELETE","header":[],"url":{"raw":"{{baseUrl}}/clients/:uuid","host":["{{baseUrl}}"],"path":["clients",":uuid"],"variable":[{"key":"uuid"}]}},"status":"OK","code":200,"_postman_previewlanguage":"text","header":[],"cookie":[],"responseTime":null,"body":""}],"_postman_id":"b9515a9f-0656-4bd2-bff6-80989bbc0530"}],"id":"62f3553b-3924-4445-bd32-a719e823d0ba","_postman_id":"62f3553b-3924-4445-bd32-a719e823d0ba","description":""},{"name":"Retrieve Clients","id":"de49be9d-39d3-4f88-95c0-34712eafb914","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":"{{baseUrl}}/clients?page=-83476782&pageSize=-83476782&client=labore laborum fug","description":"<p>This API retrieves Clients. \nIf the pagination parameters are left empty , 10 Clients are retrieved. \nThe results are sorted by name and UUID.</p>\n","urlObject":{"path":["clients"],"host":["{{baseUrl}}"],"query":[{"description":{"content":"<p>Used in conjunction with pageSize for pagination. \nStarts from 0. For example , to fetch the first 50 clients, use page = 0 and pageSize = 50. \nThis parameter is optional. If left blank, it defaults to 0.</p>\n","type":"text/plain"},"key":"page","value":"-83476782"},{"description":{"content":"<p>This parameter is optional. If left blank, it defaults to 10.</p>\n","type":"text/plain"},"key":"pageSize","value":"-83476782"},{"description":{"content":"<p>The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.</p>\n","type":"text/plain"},"key":"client","value":"labore laborum fug"}],"variable":[]}},"response":[{"id":"4fc0cc95-9409-42a9-af3e-3abb8feb736e","name":"successful operation","originalRequest":{"method":"GET","header":[{"key":"Accept","value":"application/xml"}],"url":{"raw":"{{baseUrl}}/clients?page=-83476782&pageSize=-83476782&client=labore laborum fug","host":["{{baseUrl}}"],"path":["clients"],"query":[{"description":"Used in conjunction with pageSize for pagination. \r\nStarts from 0. For example , to fetch the first 50 clients, use page = 0 and pageSize = 50. \r\nThis parameter is optional. If left blank, it defaults to 0.","key":"page","value":"-83476782"},{"description":"This parameter is optional. If left blank, it defaults to 10.","key":"pageSize","value":"-83476782"},{"description":"The datascalehr Client UUID or name. Note that name is case sensitive.This parameter is optional.","key":"client","value":"labore laborum fug"}]}},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"[\n  {\n    \"UUID\": \"quis \",\n    \"Name\": \"aute non\",\n    \"Status\": \"Deleting\"\n  },\n  {\n    \"UUID\": \"aute\",\n    \"Name\": \"cillum irure Ut commod\",\n    \"Status\": \"Soft_Delete\"\n  }\n]"}],"_postman_id":"de49be9d-39d3-4f88-95c0-34712eafb914"},{"name":"Create a new Client","id":"a458121c-7807-480a-8581-2c825d1e628c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"dolore aute cillum\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/clients","urlObject":{"path":["clients"],"host":["{{baseUrl}}"],"query":[],"variable":[]}},"response":[{"id":"35581258-9407-4472-b214-0db7730c5211","name":"successful operation","originalRequest":{"method":"POST","header":[{"key":"Content-Type","value":"application/json"},{"key":"Accept","value":"application/xml"}],"body":{"mode":"raw","raw":"{\n  \"Name\": \"dolore aute cillum\"\n}","options":{"raw":{"headerFamily":"json","language":"json"}}},"url":"{{baseUrl}}/clients"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"}],"cookie":[],"responseTime":null,"body":"{\n  \"UUID\": \"irure non ut laboris\",\n  \"Name\": \"officia labore ex aliqua exercitation\",\n  \"Status\": \"Active\"\n}"}],"_postman_id":"a458121c-7807-480a-8581-2c825d1e628c"}],"id":"43e5a50d-57d1-4129-a006-48c44d474e36","description":"<ul>\n<li><p>List all clients with pagination support</p>\n</li>\n<li><p>Retrieve specific client details by UUID</p>\n</li>\n<li><p>Filter by client name or UUID</p>\n</li>\n<li><p>Track client status (Active, Deleting)</p>\n</li>\n</ul>\n","_postman_id":"43e5a50d-57d1-4129-a006-48c44d474e36"}],"id":"56bb488d-0e0c-4025-8295-39432da39b6e","description":"<p>Manage your organizational hierarchy and structure:</p>\n","_postman_id":"56bb488d-0e0c-4025-8295-39432da39b6e"}]}