Visit Freshworks.com Visit Freshworks

Replies posted by pjg_west

1 Reply

P
Apprentice
pjg_westApprentice
asked in API and Webhooks

Export all products to a Excel Workbook using the API

After no response here and a lot of googling I asked ChatGPT and it provided me the below solution, it may be of use to someone else…. let    getPage = (page as number) =>        try Json.Document(            Web.Contents(                "https://XXXXXX.freshservice.com/api/v2/products?per_page=100&page=" & Text.From(page),                [Headers=[Authorization="Basic XXXXXXXXXX"]]            )        ) otherwise null,    pageList = List.Generate(        () => 1,        each not List.IsEmpty(getPage(_)[products]),        each _ + 1,        each getPage(_)    ),    #"Converted to Table" = Table.FromList(pageList, Splitter.SplitByNothing(), null, null, ExtraValues.Error),    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"products"}, {"products"}),    #"Expanded products" = Table.ExpandListColumn(#"Expanded Column1", "products"),    #"Expanded products1" = Table.ExpandRecordColumn(#"Expanded products", "products", {"id", "created_at", "up

1
seolinks786
Community Debut
11 months ago

Badge winners

Show all badges
Terms of UseCookie settings