I'm trying to pull the data from the newest Jira cloud API (v3) and they produce a json that looks like this:
{
issues: [
1,
2,
3
],
nextPageToken : "string"
}
nextPageToken is nullable, that is it is absent on the last page of the result.
I'm having trouble with the function that gets the next page which looks like this:
// Function to fetch data using next page token
FetchJiraData = (NextPageToken as nullable text) =>
let
ApiUrl = if NextPageToken = null then
BaseUrl & "jql=project=myproj&maxResults=" & Number.ToText(PageSize)
else
//NextPageToken, // Use nextPage URL
BaseUrl & "jql=project=myproj&maxResults=" & Number.ToText(PageSize) & "nextPageToken=" & NextPageToken, // Use nextPage URL
Source = Json.Document(Web.Contents(ApiUrl, headers)),
Issues = try Source[issues] otherwise {},
NextPageToken = try Source[nextPageToken] otherwise null
in
[Data = Issues, NextToken = NextPageToken]
When calling the function, I get
Expression.Error: We cannot convert a value of type Record to type Function.
Details:
Value=[Record]
Type=[Type]
Any help will be appreciated!
