APIs & Integrations

kbarhoover
Participant

Parsing API Response

I'm successfully pulling email event (Sent) data via the below. 

 

https://api.hubapi.com/email/public/v1/events?hapikey=xxxxxx&startTimestamp=1554868800000&limit=2&ev...

 

How can I parse this response so it can be used in something like MS Access?

Thanks

0 Upvotes
1 Reply 1
cbarley
HubSpot Alumni
HubSpot Alumni

Parsing API Response

Hi @kbarhoover ! I won't be able to offer a ton about how to do this type of thing as MS Access's APIs are foreign to me. If anybody in the community has other ideas, feel free to comment. 

 

Normally, with questions like this, if the integration doesn't exist in our Partner Directory, I'd recommend a freelancer, or going with something like Stitch, or using some other third party tool that you might be able to find. 

 

All I was able to find on the connection was through CDATA: https://www.cdata.com/kb/tech/hubspot-odbc-access-linked-tables.rst, and something called cloudpipes: https://www.cloudpipes.com/integrations/hubspot/microsoft-access

0 Upvotes