getallTulipTableRecords in Excel

Hi,

you can get all records from tulip table thanks to BOT.

For this you need to use powerQuery functionnality on Excel.
You can easily copy the function in advanced editor (see below)

(TulipTableId as text) as table=>

let
Query = #table( type table [#“TulipTableId” = text], { {TulipTableId}}),
Function = Table.AddColumn(Query, “Offset”, Number.Round(Json.Document(Web.Contents(“https://[server]/api/v3/tables/”& TulipTableId &"/count"))/100)),
ExpandedOffset =Table.ExpandListColumn(Function, “Offset”),
NbLoop=Number.Round(Json.Document(Web.Contents(“https://[server]/api/v3/tables/”& TulipTableId &"/count"))/100),
TableOffset=Table.FromList(List.Transform({0…NbLoop},each Number.ToText(_*100))),
TableOffset1=Table.RenameColumns(TableOffset,{{“Column1”, “Offset”}}),
TulipTable= Table.AddColumn(TableOffset1, “Records”, each Table.FromRecords(Json.Document(Web.Contents(“https://[server]/api/v3/tables/” & TulipTableId & “/records?limit=100&offset=”& [Offset] &"&sortBy=_sequenceNumber&sortDir=asc"))))

in
TulipTable

Do not forget to change the variable [server] by your server name.

The function set, you can get all records from your tulip table by invoke the function and copy/paste your Tulip Table Id.

4 Likes