Hey all, wondering if anyone has recent experience...
# plugins-general
d
Hey all, wondering if anyone has recent experience getting
tap-quickbooks
working in Meltano. I’ve got it working with
invoke
by manually passing in the properties file, but I’d really like to get it to sync via
elt
to
target-postgres
. I saw the threads from a year ago and 8 months ago, but it looks like the general consensus was that you could use the tap a la:
Copy code
meltano invoke tap-quickbooks \
  --properties .meltano/run/tap-quickbooks/tap.properties.json \
  --catalog .meltano/run/tap-quickbooks/tap.properties.json > records.json
New to meltano + singer + etc, so looking for advice on how to either get something like the following
Copy code
meltano elt tap-quickbooks target-postgres
working, or at least how to feed
records.json
from the first example to the
target-postgres
Thoughts?
t
what does your meltano.yml look like? I’m looking at https://hub.meltano.com/extractors/tap-quickbooks and it seems like the metadata is incorrect. If you add:
Copy code
capabilities:
- properties
- discover
- state
to the definition of tap-quickbooks then it should work. Meltano handles the generation of the catalog/properties json for you. Also note that
properties
and
catalog
are synonymous, but
properties
is deprecated in favor of
catalog
.
I’ve made a PR to get this updated in the metadata https://github.com/meltano/hub/pull/744
p
@david_welch I'm not sure if that solves your problem but the change is merged so if you run
meltano lock tap-quickbooks --update
you should pull in the updated definition (assuming your on meltano version >=2.0)
d
Whoa awesome, thanks @pat_nadolny and @taylor!
I did make the capabilities change, but it turned out my selects were also invalid. I had
*.*
, which failed to match anything
had a buddy jump in and try to reproduce, and he explicitly listed his selected entities and things worked - but only if he specifically excluded a few entities (PayrollReport or something… will check into it and see what I can reproduce)
But overall, I’m blown away 😄 Meltano is awesome, and I’m now considering all the taps I’ve ever needed 😉