Hop til hovedindhold

Emigo.Contents

Syntax​

Emigo.Contents(
    optional DataRestrictionType as text,
    optional DataRestrictionValue as text,
    optional DataRestrictionMode as text,
    optional AuthorizationMode as text
) as table

Remarks​

The purpose of the method is to set parameters for odata feed data source calls, thus the non-function calls may be limited by, for example, the period

Examples​

Example #1​

The purpose of the function is set the feed call parametrs

let
    Source = Emigo.Contents("DAYS", "3", "exact", null),
    emigoList = Source{[Key="emigoList"]}[Data],
    Dziennik_table = emigoList{[Name="Dziennik",Signature="table"]}[Data],
    #"Removed Columns" = Table.RemoveColumns(Dziennik_table,{"CzasWykonywaniaSekundy", "CzyCzasUKlienta", "CzyCzasDojazdu", "CzyZdjecia", "Odrzucona", "Obligatoryjna", "Wykonana", "DataCzasRozpoczecia", "DataGodzina", "Data", "Hierarchia", "IDCzynnosciTypy", "IDDziennikGrup", "IDGrupaDocelowa", "IDLogin", "IDKlient", "IdPrzOdm", "IDZadania", "IDTypZadania", "IDTME", "SekundyMiedzyCzynnosciami", "IloscZdjec", "OkresWykonywaniaSekundy", "CzyZadanieWykonane", "AnulowaneNaTME", "OdlegloscKlientKM", "IDKatZad"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each true)
in
    #"Filtered Rows"

Result:

"#Filtered Rows"({"IDDZiennik", "DataNumerycznie"}, {{132806, 20190220}, {132803, 20190220}})