Export Forecasting Data via Fivetran?

[NArtadi]

Hello all!

Is it possible to extract data via Fivetran on the Forecast section / object?

This is my case: We need to export automatically every month the data from Sales Forecast tools, specifically the value under forecast submission.

Best case scenario we get everything, but we need to get specifically that column.

I was not able to find the information I require, had a look through this Fivetran page and this CRM API page.

[LBossi]

@NArtadi were you able to find a solution?

As far as I got, that's a general limitation of the HubSpot API scopes. The scopes don't cover everything that's available in the UI. There's nothing that those connectors can do (Fivetran, Stitch, Supermetrics, etc) unless HubSpot includes a API endpoint that allows us to fetch "forecast specific" fields.

[NArtadi · Accepted solution]

Hey! No solution besides a manual copy paste only. Because it's also not possible to extract the data through an export. We've tried several times.

We use Okta as an SSO tool, it will cost us more to write a script to extract this.

Are there any plans to make this available?

[MiaSrebrnjak]

Hi @NArtadi,

Thank you for reaching out to the Community!

I'll tag a couple of users who have worked with Fivetran in the past: 

hi @TEnns, @netlify-data, @Fivetran, @VM1, do you have any advice for @NArtadi? Thank you!

Cheers
Mia, Community Team      

[NArtadi]

Thank you! I am trying to get all data in Sales>Forecast