0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

Adobe Analytics API 2.0 で、任意のWorkspace table からデータを取得

Posted at

Adobe Analytics API 2.0 の使い方は、このビデオで一通りわかります。
https://experienceleague.adobe.com/docs/analytics-learn/tutorials/apis/using-analysis-workspace-to-build-api-2-requests.html?lang=en#apis

具体的に、Python のプログラムに置き換える方法は以下の通り。

  1. Swagger UI からCURL をコピー

  2. CURL を Python に変換 @ https://curl.trillworks.com/

    response = requests.post('https://analytics.adobe.io/api/*******/reports', headers=headers, data=data)

    というコマンド終わるPython script が取り出せます。

3.上記のPython script に続けて、以下の変換できれいなデータテーブルが得られます。

j = response.json()['rows']
df = pd.DataFrame(j)
pd.concat([df['value'],df['data'].apply(pd.Series)], axis = 1)

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?