EmployerLastModifiedVersionNumbersByUser |
List of employer last modified version numbers__Activity name :__ GetEmployerLastModifiedVersionNumbersByUser**What does the 'last modified' version number reflect**The sequence number of an employer is a sequential number that reflects whether any changes have occurred in any of its UNDERLYING employments.More precisely, it reflects the sequence number after the latest change of any database record that relates to an employment within this employer. What we consider to be 'underlying' employment data is based on a predefined set of tables, and of course given id. This predefined set of tables can be found [here](../TablesLastModifiedVersionNumber.xlsx)The scope of this predefined set is to represent 'static' employment data (vaste gegevens), and thus excludes payroll period data (variabele gegevens).**When to use**This endpoint is most useful for integrations that regularly synchronize Loket employment data with another system. As there are no webhooks available, in practice these integrations would need to regularly poll all data to see whether there any changes in the employment data. The most elementary approach of getting all employment data every time you sync acquires a LOT of calls, in some cases even millions per day. Even though we can handle quite a lot, this is not always the desired way for both client and server. Hence, this endpoint enables an alternative solution to set up such an integration.**How to use**With every update (including additions and deletions) the version number will increase. I.e. the version number will NEVER decrease over time. (Please note this is not only true within the context of a single employer (or any other entity) but applies to all changes in the database).Consequently, in practice one would use this endpoint to check if any empLoyer version numbers have increased by applying the filter query parameter to the version field, for example `?filter=version gt 70429274`.*Recommended usage** Perform your regular synchronization of static employment data* Store the highest version number, for which you have now processed all changes. (You may use the following parameter to do this `?orderBy=-lastModifiedVersionNumber` )* Next time you want to perform synchronization. Call this endpoint with parameter `?filter=lastModifiedVersionNumber gt {{YourVersionNumber}}`* Only get employment information for employers that are included in that filtered list. (exclude all other employers as you already know there have been no changes since the last synchronization)
Catalogus: LoketNlRest
Schema: LastModifiedVersionNumbers
Dit is een alleen-lezen tabel. De Loket.nl REST API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Loket.nl REST ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Loket.nl REST-API.
Tabelkolommen
De kolommen van de tabel EmployerLastModifiedVersionNumbersByUser worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
id |
guid |
ID |
☐ |
The unique identifier of an object (GUID/UUID) |
lastModifiedVersionNumber |
int64 |
|
☐ |
The version number reflects the latest version of all predefined underlying tables of this employer/employment. |
10-06-2024 18:51 Versie 24.1.3-BETA+4689