Definice ELDP

GET

/retirementreportdefs

Získá kolekci BO Definice ELDP

GET

/retirementreportdefs/meta/dataprotection

Získá seznam položek BO, které mohou být chráněny na BO Definice ELDP

GET

/retirementreportdefs/views/{view}

Získá pohled nad BO Definice ELDP

GET

/retirementreportdefs/{id}

Získá daný BO Definice ELDP

GET

/retirementreportdefs/{id}/iseditlock

Otestuje, zda existuje editační zámek na daném BO Definice ELDP

GET

/retirementreportdefs/{id}/meta/dataprotection

Získá seznam chráněných položek, které jsou na BO Definice ELDP aktuálnímu uživateli znepřístupněny

GET

/retirementreportdefs/{id}/rows

Získá řádky kolekce Řádek definice ELDP

GET

/retirementreportdefs/{id}/rows/{id1}

Získá daný řádek kolekce Řádek definice ELDP

GET

/retirementreportdefs/{id}/userparameters

Získá seznam uživatelských parametrů včetně jejich hodnot k danému BO Definice ELDP

POST

/retirementreportdefs

Vytvoří nový BO Definice ELDP

POST

/retirementreportdefs/query

Vyhodnotí query dotaz nad BO Definice ELDP

POST

/retirementreportdefs/{id}/rows

Vytvoří nový řádek v kolekci Řádek definice ELDP

PUT

/retirementreportdefs/{id}

Modifikuje daný BO Definice ELDP

PUT

/retirementreportdefs/{id}/editlock

Vytvoří editační zámek na daném BO Definice ELDP

PUT

/retirementreportdefs/{id}/editunlock

Zruší editační zámek na daném BO Definice ELDP

PUT

/retirementreportdefs/{id}/rows/{id1}

Modifikuje řádek v kolekci Řádek definice ELDP

DELETE

/retirementreportdefs/{id}

Smaže BO Definice ELDP

DELETE

/retirementreportdefs/{id}/rows/{id1}

Smaže řádek z kolekce Řádek definice ELDP

Metadata - Perzistentní položky

calendaryear integer

Rok, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu

name string (50)

Název, pole vlastněné tabulkou, možné řadit a filtrovat, pole je duplikováno při klonování objektu

objversion integer

Verze objektu, pouze pro čtení, pole vlastněné tabulkou, možné řadit a filtrovat, pole nepodporuje ochranu dat/GDPR

rows array (retirementreportdefrow) relace

kolekce BO Řádek definice ELDP, pole je duplikováno při klonování objektu, objekt na který pole odkazuje je 'vlastněn'

Metadata - Neperzistentní položky

classid string (26)

ID třídy, pouze pro čtení, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR

displayname string (100)

Název, pouze pro čtení

id string (10)

Vlastní ID, pouze pro čtení, fkAnsiCaseSensitive, pole nepodporuje ochranu dat/GDPR

Příklady
  • GET
  • QUERY
  • POST
  • PUT
  • DELETE
  • BATCH
  • Builder
Request 
GET
https://atd.abra.eu/demodata/retirementreportdefs?take=1
GET
https://atd.abra.eu/demodata/retirementreportdefs/{id}
Response 
{
    "objversion": 1,
    "rows": [
        {
            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
            "fieldname": "ZakladSP",
            "id": "1000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "S_SmallOrBigCompany",
            "fieldname": "MalaOrganizace",
            "id": "2000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
            "fieldname": "OdecteneDny",
            "id": "3000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
            "fieldname": "VylouceneDny",
            "id": "4000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
            "fieldname": "VylouceneDnyVDuchodu",
            "id": "5000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
            "fieldname": "Spolecnik",
            "id": "6000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        }
    ],
    "name": "Definice ELDP 2004",
    "calendaryear": 2004
}
Request POST 
POST
https://atd.abra.eu/demodata/query
{"class": "retirementreportdefs", "take": "1"}
POST
https://atd.abra.eu/demodata/retirementreportdefs/query
{"take": "1"}
Response 
{
    "objversion": 1,
    "rows": [
        {
            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
            "fieldname": "ZakladSP",
            "id": "1000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "S_SmallOrBigCompany",
            "fieldname": "MalaOrganizace",
            "id": "2000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
            "fieldname": "OdecteneDny",
            "id": "3000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
            "fieldname": "VylouceneDny",
            "id": "4000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
            "fieldname": "VylouceneDnyVDuchodu",
            "id": "5000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
            "fieldname": "Spolecnik",
            "id": "6000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        }
    ],
    "name": "Definice ELDP 2004",
    "calendaryear": 2004
}
Request 
POST
https://atd.abra.eu/demodata/retirementreportdefs?select=id
Body 
{
    "calendaryear": 2004,
    "name": "Definice ELDP 2004",
    "rows": [
        {
            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
            "fieldname": "ZakladSP",
            "id": "1000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "S_SmallOrBigCompany",
            "fieldname": "MalaOrganizace",
            "id": "2000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
            "fieldname": "OdecteneDny",
            "id": "3000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
            "fieldname": "VylouceneDny",
            "id": "4000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
            "fieldname": "VylouceneDnyVDuchodu",
            "id": "5000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
            "fieldname": "Spolecnik",
            "id": "6000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        }
    ]
}
Response 
{
    "id": "1600000101"
}
Request 
PUT
https://atd.abra.eu/demodata/retirementreportdefs/{id}?select=id
Body 
{
    "calendaryear": 2004,
    "name": "Definice ELDP 2004",
    "rows": [
        {
            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
            "fieldname": "ZakladSP",
            "id": "1000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "S_SmallOrBigCompany",
            "fieldname": "MalaOrganizace",
            "id": "2000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
            "fieldname": "OdecteneDny",
            "id": "3000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
            "fieldname": "VylouceneDny",
            "id": "4000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
            "fieldname": "VylouceneDnyVDuchodu",
            "id": "5000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        },
        {
            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
            "fieldname": "Spolecnik",
            "id": "6000000000",
            "objversion": 1,
            "parent_id": "1000000000"
        }
    ]
}
Response 
{
    "id": "1600000101"
}
DELETE
https://atd.abra.eu/demodata/retirementreportdefs/{id}
Response 
200 - OK Everything worked as expected.
Dávkové zprocování záznamů Request 
PUT
https://atd.abra.eu/demodata//batch
  • CREATE
  • UPDATE
  • DELETE
Body - Create 
{
    "items": [
        {
            "type": "create",
            "id": "id0",
            "data": {
                "class_id": "retirementreportdefs",
                "object_data": {
                    "calendaryear": 2004,
                    "name": "Definice ELDP 2004",
                    "rows": [
                        {
                            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
                            "fieldname": "ZakladSP",
                            "id": "1000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "S_SmallOrBigCompany",
                            "fieldname": "MalaOrganizace",
                            "id": "2000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
                            "fieldname": "OdecteneDny",
                            "id": "3000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
                            "fieldname": "VylouceneDny",
                            "id": "4000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
                            "fieldname": "VylouceneDnyVDuchodu",
                            "id": "5000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
                            "fieldname": "Spolecnik",
                            "id": "6000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        }
                    ]
                },
                "query": {
                    "select": [
                        "id"
                    ]
                }
            }
        },
        {
            "type": "create",
            "id": "id1",
            "data": {
                "class_id": "retirementreportdefs",
                "object_data": {
                    "calendaryear": 2004,
                    "name": "Definice ELDP 2004",
                    "rows": [
                        {
                            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
                            "fieldname": "ZakladSP",
                            "id": "1000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "S_SmallOrBigCompany",
                            "fieldname": "MalaOrganizace",
                            "id": "2000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
                            "fieldname": "OdecteneDny",
                            "id": "3000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
                            "fieldname": "VylouceneDny",
                            "id": "4000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
                            "fieldname": "VylouceneDnyVDuchodu",
                            "id": "5000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
                            "fieldname": "Spolecnik",
                            "id": "6000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        }
                    ]
                },
                "query": {
                    "select": [
                        "id"
                    ]
                }
            }
        }
    ]
}
Body - Update 
{
    "items": [
        {
            "type": "update",
            "id": "id0",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000100",
                "object_data": {
                    "calendaryear": 2004,
                    "name": "Definice ELDP 2004",
                    "rows": [
                        {
                            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
                            "fieldname": "ZakladSP",
                            "id": "1000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "S_SmallOrBigCompany",
                            "fieldname": "MalaOrganizace",
                            "id": "2000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
                            "fieldname": "OdecteneDny",
                            "id": "3000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
                            "fieldname": "VylouceneDny",
                            "id": "4000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
                            "fieldname": "VylouceneDnyVDuchodu",
                            "id": "5000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
                            "fieldname": "Spolecnik",
                            "id": "6000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        }
                    ]
                },
                "query": {
                    "select": [
                        "id"
                    ]
                }
            }
        },
        {
            "type": "update",
            "id": "id1",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000101",
                "object_data": {
                    "calendaryear": 2004,
                    "name": "Definice ELDP 2004",
                    "rows": [
                        {
                            "expression": "NxRoundByValue(S_SocialInsBaseCorrect + if(MainWorkingRelation and not NxIsEmptyOID(WageListCommon_ID.ID), WageListCommon_ID.S_RetFundTaxBase, 0), 2, 1)",
                            "fieldname": "ZakladSP",
                            "id": "1000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "S_SmallOrBigCompany",
                            "fieldname": "MalaOrganizace",
                            "id": "2000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_SubtractedDaysTotal')",
                            "fieldname": "OdecteneDny",
                            "id": "3000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysCorrect')",
                            "fieldname": "VylouceneDny",
                            "id": "4000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "WageListRecalculatedValue(ID, 'MDPojist', 'S_ExcludedDaysAfterRetAge')",
                            "fieldname": "VylouceneDnyVDuchodu",
                            "id": "5000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        },
                        {
                            "expression": "if(WageEmployeeValueHistory('IsPartner', True, NxStrToDate('01.01.' + WagePeriod_ID.WPeriodYear) ,NxStrToDate('31.12.' + WagePeriod_ID.WPeriodYear), WorkingRelation_ID.Employee_ID.ID,'MM') <> '', 1, 0)",
                            "fieldname": "Spolecnik",
                            "id": "6000000000",
                            "objversion": 1,
                            "parent_id": "1000000000"
                        }
                    ]
                },
                "query": {
                    "select": [
                        "id"
                    ]
                }
            }
        }
    ]
}
Body - Delete 
{
    "items": [
        {
            "type": "delete",
            "id": "id0",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000100"
            }
        },
        {
            "type": "delete",
            "id": "id1",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000101"
            }
        },
        {
            "type": "delete",
            "id": "id2",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000102"
            }
        },
        {
            "type": "delete",
            "id": "id3",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000103"
            }
        },
        {
            "type": "delete",
            "id": "id4",
            "data": {
                "class_id": "retirementreportdefs",
                "obj_id": "1600000104"
            }
        }
    ]
}