cancel
Showing results for 
Search instead for 
Did you mean: 

Big query Get data issue

SaiTeja3
Level 3

Hi,
I am trying to pull the data from big query using  the action bigquery .datasets. get , but I am getting the http 404 error . can some please help me on this  whether it is the right approach to pull data or any other steps is required.

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 404
HTTP Response Content: <!DOCTYPE html>
<html lang=en>
  <meta charset=utf-8>
  <meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width">
  <title>Error 404 (Not Found)!!1</title>
  <style>
    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}
  </style>
  <a href=//www.google.com/><span id=logo aria-label=Google></span></a>
  <p><b>404.</b> <ins>That's an error.</ins>
  <p>The requested URL <code>/bigquery/v2/projects/SAP_VENDOR_MGMT_REPORTING.V_MAN_HOURS_TIME_REPORT_TEST/datasets/ABC-datafoundation-qa?fields=*</code> was not found on this server.  <ins>That's all we know.</ins>

Thanks,
Sai



------------------------------
Teja Sai X (Contractor)
------------------------------

2 REPLIES 2

Hi Teja Sai,

Have you tried using the API Explorer first to check if you are able to retrieve the data. API Exploler lets you try out the BiqQuery APIs visually. Here is the link to it.

https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/get  

8376.png

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

SaiTeja3
Level 3

Hi  kumar,

I have tried it from the API Explorer and still getting the same error.

Thanks,
Sai



------------------------------
Teja Sai X (Contractor)
------------------------------