teratail
回答率
85.31%
teratail header banner
teratail header banner
質問するログイン新規登録
トップGoogle Apps Scriptに関する質問YahooAPIのv12への対応

編集履歴

質問編集履歴

7

解決

2023/09/20 12:33

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -76,3 +76,31 @@
76
76
 
77
77
  ```getContentText(): {"rid":"8309ff0dcc59fc23e593e705d468b982","errors":[{"code":"0005","message":"Bad request.","details":[]}]}```
78
78
 
79
+
80
+ ### 解決
81
+ ```
82
+ function check() {
83
+
84
+ var access_token = 'something';
85
+
86
+ var payload = {
87
+ "accountIds": []
88
+ };
89
+
90
+ var params = {
91
+ method : 'post',
92
+ contentType: 'application/json',
93
+ headers: {
94
+ 'Authorization': 'Bearer ' + access_token
95
+ },
96
+ payload: JSON.stringify(payload),
97
+ muteHttpExceptions: true
98
+ };
99
+
100
+ var response = UrlFetchApp.fetch("https://ads-search.yahooapis.jp/api/v12/BaseAccountService/get", params);
101
+
102
+ var accountId = JSON.parse(response)["rval"]["values"][0]["account"]["accountId"];
103
+
104
+ Logger.log('accountId: ' + accountId);
105
+ }
106
+ ```
Google Apps ScriptJavaScriptAPI

6

ソースコード、ログの追加

2023/09/20 08:20

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -8,7 +8,7 @@
8
8
  またそれは```BaseAccountService```で取得可能と記載があるのですが、方法が分からないので教えていただきたいです。
9
9
  下記の様に記述したのですが```Bad request```となったため質問いたしました。
10
10
 
11
- ### ソースコード
11
+ ### 試したソースコード①
12
12
 
13
13
  ```GAS
14
14
  function check() {
@@ -30,10 +30,49 @@
30
30
  Logger.log('getContentText(): ' + response.getContentText());
31
31
  }
32
32
  ```
33
- ### ログ
33
+ ### ログ①
34
34
  ```getHeaders(): {"Transfer-Encoding":"chunked","x-yahoo-ads-rid":"50577f5cbb1b1541ff25c0df4ac900a1","X-Content-Type-Options":"nosniff","X-XSS-Protection":"1; mode=block","Date":"Wed, 20 Sep 2023 06:55:57 GMT","Content-Type":"application/json;charset=UTF-8","X-Frame-Options":"SAMEORIGIN","x-vcap-request-id":"c4916d79-ea22-44e4-74fc-84bab8d34898","Connection":"keep-alive","Vary":"Access-Control-Request-Headers"}```
35
35
 
36
36
  ```getResponseCode(): 400```
37
37
 
38
38
  ```getContentText(): {"rid":"dd1fa4ef4f6af9dabace8cc3ce471056","errors":[{"code":"0005","message":"Bad request.","details":[]}]}```
39
39
 
40
+ ### 試したソースコード②
41
+
42
+ ```GAS
43
+ function check() {
44
+
45
+ var CLIENT_ID = 'something';
46
+ var CLIENT_SECRET = 'something';
47
+ var access_token = 'something';
48
+
49
+ var payload = {
50
+ client_id: CLIENT_ID,
51
+ client_secret: CLIENT_SECRET
52
+ };
53
+
54
+ var params = {
55
+ method : 'post',
56
+ contentType: 'application/json',
57
+ headers: {
58
+ 'Authorization': 'Bearer ' + access_token
59
+ },
60
+ payload: JSON.stringify(payload),
61
+ muteHttpExceptions: true
62
+ };
63
+ var response = UrlFetchApp.fetch("https://ads-search.yahooapis.jp/api/v12/BaseAccountService/get", params);
64
+
65
+ Logger.log('getHeaders(): ' + JSON.stringify(response.getHeaders()));
66
+ Logger.log('getResponseCode(): ' + response.getResponseCode());
67
+ Logger.log('getContentText(): ' + response.getContentText());
68
+ }
69
+ ```
70
+
71
+ ### ログ②
72
+
73
+ ```getHeaders(): {"X-Frame-Options":"SAMEORIGIN","X-Content-Type-Options":"nosniff","x-vcap-request-id":"52eae2bc-dc0d-4242-6470-2ae6d0934bcf","Content-Type":"application/json;charset=UTF-8","Vary":"Access-Control-Request-Headers","Transfer-Encoding":"chunked","Connection":"keep-alive","Date":"Wed, 20 Sep 2023 08:15:16 GMT","X-XSS-Protection":"1; mode=block","x-yahoo-ads-rid":"8309ff0dcc59fc23e593e705d468b982"}```
74
+
75
+ ```getResponseCode(): 400```
76
+
77
+ ```getContentText(): {"rid":"8309ff0dcc59fc23e593e705d468b982","errors":[{"code":"0005","message":"Bad request.","details":[]}]}```
78
+
Google Apps ScriptJavaScriptAPI

5

エラー内容の修正

2023/09/20 06:56

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -31,7 +31,7 @@
31
31
  }
32
32
  ```
33
33
  ### ログ
34
- ```getHeaders(): [object Object]```
34
+ ```getHeaders(): {"Transfer-Encoding":"chunked","x-yahoo-ads-rid":"50577f5cbb1b1541ff25c0df4ac900a1","X-Content-Type-Options":"nosniff","X-XSS-Protection":"1; mode=block","Date":"Wed, 20 Sep 2023 06:55:57 GMT","Content-Type":"application/json;charset=UTF-8","X-Frame-Options":"SAMEORIGIN","x-vcap-request-id":"c4916d79-ea22-44e4-74fc-84bab8d34898","Connection":"keep-alive","Vary":"Access-Control-Request-Headers"}```
35
35
 
36
36
  ```getResponseCode(): 400```
37
37
 
Google Apps ScriptJavaScriptAPI

4

文言修正

2023/09/20 06:27

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -6,7 +6,7 @@
6
6
 
7
7
  [こちら](https://ads-developers.yahoo.co.jp/ja/ads-api/announcement/230817.html)にて今後は```リクエストヘッダーにx-z-base-account-idの指定が必須```と記載があります。
8
8
  またそれは```BaseAccountService```で取得可能と記載があるのですが、方法が分からないので教えていただきたいです。
9
- 下記の様に記述したのですが```Invalid Request```となったため質問いたしました。
9
+ 下記の様に記述したのですが```Bad request```となったため質問いたしました。
10
10
 
11
11
  ### ソースコード
12
12
 
@@ -31,13 +31,9 @@
31
31
  }
32
32
  ```
33
33
  ### ログ
34
- ```ここに言語を入力
35
- getHeaders(): [object Object]
34
+ ```getHeaders(): [object Object]```
36
- ```
37
- ```ここに言語を入力
38
- getResponseCode(): 400
39
- ```
40
- ```ここに言語を入力
41
- getContentText(): {"rid":"dd1fa4ef4f6af9dabace8cc3ce471056","errors":[{"code":"0005","message":"Bad request.","details":[]}]}
42
- ```
43
35
 
36
+ ```getResponseCode(): 400```
37
+
38
+ ```getContentText(): {"rid":"dd1fa4ef4f6af9dabace8cc3ce471056","errors":[{"code":"0005","message":"Bad request.","details":[]}]}```
39
+
Google Apps ScriptJavaScriptAPI

3

文言修正

2023/09/20 06:26

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -30,7 +30,7 @@
30
30
  Logger.log('getContentText(): ' + response.getContentText());
31
31
  }
32
32
  ```
33
- ### エラー
33
+ ### ログ
34
34
  ```ここに言語を入力
35
35
  getHeaders(): [object Object]
36
36
  ```
Google Apps ScriptJavaScriptAPI

2

現状のコードを修正

2023/09/20 06:25

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
@@ -10,23 +10,34 @@
10
10
 
11
11
  ### ソースコード
12
12
 
13
- ```ここに言語名を入力
13
+ ```GAS
14
14
  function check() {
15
-
16
15
  var access_token = 'something';
17
16
 
18
17
  var params = {
18
+ method: 'post',
19
+ contentType: 'application/json',
19
20
  headers: {
20
21
  'Authorization': 'Bearer ' + access_token
21
22
  },
22
- method: 'get',
23
23
  muteHttpExceptions: true
24
24
  }
25
25
 
26
26
  var response = UrlFetchApp.fetch("https://ads-search.yahooapis.jp/api/v12/BaseAccountService/get", params);
27
+
28
+ Logger.log('getHeaders(): ' + response.getHeaders());
29
+ Logger.log('getResponseCode(): ' + response.getResponseCode());
27
- var response_body = JSON.parse(response.getContentText());
30
+ Logger.log('getContentText(): ' + response.getContentText());
28
- Logger.log(response_body);
29
31
  }
30
32
  ```
33
+ ### エラー
34
+ ```ここに言語を入力
35
+ getHeaders(): [object Object]
36
+ ```
37
+ ```ここに言語を入力
38
+ getResponseCode(): 400
39
+ ```
40
+ ```ここに言語を入力
41
+ getContentText(): {"rid":"dd1fa4ef4f6af9dabace8cc3ce471056","errors":[{"code":"0005","message":"Bad request.","details":[]}]}
42
+ ```
31
43
 
32
-
Google Apps ScriptJavaScriptAPI

1

タグの修正

2023/09/20 00:26

投稿

quwant
quwant

スコア5

test CHANGED
File without changes
test CHANGED
File without changes
Google Apps ScriptJavaScriptAPI
Java
JavaScript