Qlik Community

Ask a Question

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MarkimTI
Contributor
Contributor

API PowerBI para funcionar em QlikSense

Prezados,

Gostaria de uma ajuda para realizar essa conexão em QlikSense. Realizei um teste e no Power BI conecta normalmente.
No powerbi mudei só o Key e o Board e conectou.

Como ficaria no script do QlikSense?

 

// Queries Monday.com items from a specific board
// Replace the API Key and Board ID for it to work

let
Key = "YOUR MONDAY API KEY V2",
Board = "YOUR MONDAY BOARD ID NUMBER",
Source = Web.Contents("https://api.monday.com/v2",
[
Headers=[
#"Method"="POST",
#"Content-Type"="application/json",
#"Authorization"="Bearer " & Key
],
Content=Text.ToBinary("{""query"": ""query { boards(ids: " & Board & ") { items { name, updated_at, group { title }, columns: column_values { title, text } } } }""}")
]
),
Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {"Title", "UpdatedAt", "Group", "Columns"}),
#"Monday" = Table.FromRecords(Table.TransformRows(Data, each
List.Accumulate([Columns], [
Title = [Title],
UpdateDate = [UpdatedAt],
Group = [Group][title]
], (state, current) => Record.AddField(state, current[title], current[text]) )
))
in
#"Monday"

0 Replies