# Unable to pull data via API - Response please? **URL:** \ **Category:** APIs & Integrations\ **Created:** [July 31, 2018, 7:09pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816 "2018-07-31T19:09:27Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [July 31, 2018, 7:09pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/1 "2018-07-31T19:09:27Z")
Hey, I posted this over a week ago and still haven’t gotten a response. It’s quite urgent, I would really appreciate your help. We are trying to bring hubspot data into Datorama using your API, the user we used for the API is Super Admin ([yael.cohen@datorama.com](mailto:yael.cohen@datorama.com)). We managed to connect but were unable to receive any data. This is the error we received: {“status”:400,“error”:“Bad Request”,“message”:“Bad Request”,“detailedMessage”:“{“status”:“error”,“message”:“invalid offset”,“correlationId”:“96dd307e-8533-4019-96af-171e1c4cbd19”,“requestId”:“924211131cdaee59c1bb59a3218a41a0”}”} LandingzoneException [processError=PROVIDER\_BAD\_REQUEST,Message={“status”:400,“error”:“Bad Request”,“message”:“Bad Request”,“detailedMessage”:“{“status”:“error”,“message”:“invalid offset”,“correlationId”:“96dd307e-8533-4019-96af-171e1c4cbd19”,“requestId”:“924211131cdaee59c1bb59a3218a41a0”}”}] Thanks! ![slightly_smiling_face.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/4/2/42c4d129a1c6aa74d89f3066ee8fbb15db46b3b5.png) ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 7, 2018, 12:54pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/2 "2018-08-07T12:54:03Z")
Orl, Could you please send in some more detail on your HTTP request. What Data are you trying to get out of HubSpot? ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 8, 2018, 2:33pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/3 "2018-08-08T14:33:00Z")
Hey, thanks for responding. Sure, The reason why we want to connect Hubspot to Datorama is to analyze stats related to emails that we send, specifically the Training Newsletter emails. So the data we’re trying to get is general email details (internal name, subject, sent date…) and everything that you see in the [performance](https://app.hubspot.com/email/2635477/details/5984693798/performance) page - For example: Open rate, Unique opens, Total opens, Click rate, Click through rate, Unique clicks, Top clicked links, Top engaged contacts, Time spent viewing email and more. I don’t why we keep getting an error? Thanks! ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 8, 2018, 3:23pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/4 "2018-08-08T15:23:56Z")
Have you gone through the documentation on this page? [https://developers.hubspot.com/docs/methods/email/email\_events\_overview](https://developers.hubspot.com/docs/methods/email/email_events_overview) Alternatively, you can make the export to CSV manually within HubSpot at this URL [https://app.hubspot.com/email/^yourportal$/manage/state/all](https://app.hubspot.com/email/%5Eyourportal%24/manage/state/all) I ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 9, 2018, 8:34am UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/5 "2018-08-09T08:34:05Z")
Hi Alexander, Thanks for your response, the thing is we got in with Super Admin, but we didn’t even manage import data. We just got an error. Thanks, I appreciate it! ---
**Author:** ![Derek\_Gervais](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/derek_gervais/32/17429_2.png) [@Derek\_Gervais](https://community.hubspot.com/u/Derek_Gervais)\ **Post date:** [August 15, 2018, 9:03pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/6 "2018-08-15T21:03:04Z")
Hi all, I’m not totally clear on whether or not this was resolved; is there anything else here I can help with? ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 16, 2018, 6:55am UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/7 "2018-08-16T06:55:38Z")
Hi Derek, This wasn’t resolved, we’re still struggling with importing data. I would really appreciate a solution for this. Thanks a lot! ---
**Author:** ![Derek\_Gervais](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/derek_gervais/32/17429_2.png) [@Derek\_Gervais](https://community.hubspot.com/u/Derek_Gervais)\ **Post date:** [August 21, 2018, 8:05pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/8 "2018-08-21T20:05:36Z")
Hi [@OrL](https://community.hubspot.com/u/orl), I understand; thank you for clarifying! So let’s start with the error you’re seeing. The error posted above doesn’t seem related to authentication; what’s the request you’re trying to make? Can you give me the full request URL and body, except for your access token / hapikey? ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [August 28, 2018, 9:33am UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/9 "2018-08-28T09:33:42Z")
Hi Derek, Thanks for trying to help. Please find attached the log info, describing the error. Thanks a lot, ---
**Author:** ![Derek\_Gervais](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/derek_gervais/32/17429_2.png) [@Derek\_Gervais](https://community.hubspot.com/u/Derek_Gervais)\ **Post date:** [September 10, 2018, 7:47pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/10 "2018-09-10T19:47:57Z")
Hi [@OrL](https://community.hubspot.com/u/orl), It seems like you’re responding via email; did you attach a file to the email you replied with? The built in email-to-forum-post functionality doesn’t process email attachments; you can either include the info in the body of your email, or navigate to the dev forums in a web browser and upload your attachment that way. ---
**Author:** ![system](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/system/32/124_2.png) [@system](https://community.hubspot.com/u/system)\ **Post date:** [September 12, 2018, 9:17pm UTC](https://community.hubspot.com/t/unable-to-pull-data-via-api-response-please/11816/11 "2018-09-12T21:17:17Z")
Hi Dereck, We finally managed to fix this issue internally. Thanks for trying to help! Best, Orly