python - 通过 Python api 调用从 Pendo 获取数据

Question

在 Pendo (Like adobe) 中创建了一些报告。我想通过 python api call 提取这份报告。我编写的代码部分不正确。请让我知道我做错了什么？输出应为包含 4 列及其记录的表格形式。此代码仅返回 - {'overall': {}, 'fields': {'pipeline': 'Required'}} 这很奇怪。

pendo_key='123fgh21-ab89-ab23-21ad-bvh3r11r2sv5.ca'

import matplotlib.pyplot as pt
import pandas as pd
import numpy as np
import requests
import os
import json

import pandas as pd
from io import StringIO
pd.set_option('display.max_colwidth',0)

url= "https://app.pendo.io/api/v1/aggregation"
headers = {
'X-Pendo-Integration-Key':pendo_key,
'Content-Type':'application/json'}


payload1= json.dumps({
  "response": {
    "location": "request",
    "mimeType": "application/json"
  },
  "requests": [
    {
      "name": "SalesEventAggregation",
      "pipeline": [
        {
          "source": {
            "salesEvents": {
              "blacklist": "apply",
              "salesTypeId": "dg_5w_fgtdergJ67vFdfR8kWsxi"
            },
            "timeSeries": {
              "period": "dayRange",
              "first": "now()",
              "count": 1
            }
          }
        }],
      "requestId": "saleseventAggregation-rId-etr1231-561s-6d6c-7d12-351f1d21gww2"
    }
  ]
}) 

response = requests.request("POST",url,headers=headers, data= payload1)
print("Status code:", response.status_code)
response_dict = json.loads(response.text)
response_dict




  Status code: 422
    
    Output:
    {'overall': {}, 'fields': {'pipeline': 'Required'}}

Expected:
There are 4 columns in form of table which is not showing up and their relevant records is not showing up.

标签： python