Looking to use Meltano to extract some data from H...
# plugins-general
s
Looking to use Meltano to extract some data from Hubspot - looks like I need a refresh token. How would this work? Do I need to have some configuration to always get a refresh token, then set it as an environment variable or write to a new config? Looks like there was some conversation around this a while back, but I’m not sure if there was ever a solution settled.
j
Hi sam. I was facing the same problem and solved using the "hapikey" setting. Instead use the refresh token and the other stuff, you can get the Api-Key from integration page. On the bottom of the documentation of tap-hubspot (https://github.com/singer-io/tap-hubspot) you can find " To use an API key, include a 
hapikey
 configuration variable in your 
config.json
 and set it to the value of your HubSpot API key. Any OAuth authentication parameters in your 
config.json
 will be ignored if this key is present!". Before starting the UI, follow this steps: 1. Add tap-hubspot to your project: meltano add extractor tap-hubspot 2. Config the parameter: meltano config tap-hubspot set hapikey 'your-api-key' Now you can run use the extractor. Despite the attribute "hapikey" doesnt appear on the configuration page, works well!
s
Thank you! I will check this out later today.