Recommended alternatives to Accessing PureCloud data using Excel and MSQuery?

Coffee House
1

In the past, I have used Excel and MSQuery to pull data from a database directly into Excel (where I then use VBA scripts to process the data further). In searching this forum, I didn't find much information or examples. So is the Excel/MSQuery method outdated? If yes, is there a recommended different (more modern?) approach?

2

Buenas noches, te recomiendo usar Power Query para obtener y modelar los datos para posteriormente usarlos ya sea en Excel o en Power Bi.

Ejemplo código en M
Obtener el Token para ejecutar consultas:

let 
url = "https://login.mypurecloud.com",
cliente = "YOU CLIENT ID",
Secreto = cliente & ":" & "YOU SECRET CODE",
base = Binary.ToText(Text.ToBinary(Secreto), 0),
headers = [ #"Content-Type" = "application/x-www-form-urlencoded", #"Authorization" = "Basic " & base],
postData = "grant_type=client_credentials",
response = Web.Contents(
url,
[
Headers = headers,
RelativePath = "oauth/token",
Content = Text.ToBinary(postData)
]
),
jsonResponse = Json.Document(response),
ValorToken = jsonResponse[access_token],
DuracionToken =Date.AddDays(DateTime.LocalNow(), 1),
retorno = ValorToken
in 
       retorno

Luego por ejemplo puedes obtener los datos que necesites ejemplo listado de Agentes

let
URL = "https://api.mypurecloud.com",
  headers = [#"Authorization" = "Bearer " & Token, #"Content-Type" = "application/json"],
  response = Web.Contents("https://api.mypurecloud.com/api/v2/groups/2e84af74-03ab-4a15-a964-c09bab198879/members", [
Headers = headers
]),
jsonResponse = Json.Document(response),
    entities = jsonResponse[entities]
in
entities

Espero que te sea útil.
Saludos