https://linen.dev logo
Join Slack
Powered by
I just started my first meltano project from the Q...
# getting-started
k
I just started my first meltano project from the Quickbooks accounting tap to target-CSV (default hotglue version). It ran without errors, but no CSV file was created in the specified directory. I tried again with target-jsonl, which also seems to run fine, but I see no output. Am I missing something? Attaching the yaml file and picture of output. …I’m very much a beginner, would appreciate any help or resources!
meltano-kc.yml
e
Hi @kathryn_cowie! 
meltano select tap-quickbooks --list --all
might help you see if the expected streams and attributes are selected. It looks like nothing is being selected at the moment even though you have a 
select:
in there
k
thanks @edgar_ramirez_mondragon, looks like there was a typo in selection (fields not capitalized), so I fixed that. It’s now selecting the right fields 🙂 …but when I run it, I still see no errors and no output.
Copy code
[selected ] Customer.Balance
        [excluded ] Customer.BalanceWithJobs
        [excluded ] Customer.BillAddr
        [excluded ] Customer.BillWithParent
        [selected ] Customer.CompanyName
e
Ok, I think I know what is going on. Can you do the following: • Add a 
capabilities: [properties, discover, state]
entry in 
tap-quickbooks
, maybe right below 
pip_url
? • If that doesn't work, can you try replacing the whole 
tap-quickbooks
entry with the contents below?
Copy code
- name: tap-quickbooks
    namespace: tap_quickbooks
    label: Quickbooks
    description: Accounting management platform
    docs: <https://hub.meltano.com/extractors/quickbooks.html>
    repo: <https://github.com/hotgluexyz/tap-quickbooks>
    pip_url: git+<https://github.com/hotgluexyz/tap-quickbooks.git>
    capabilities:
    - properties
    - discover
    - state
    settings_group_validation:
    - - client_id
      - client_secret
      - refresh_token
      - realmId
      - start_date
    settings:
    - name: realmId
      label: Realm ID
    - name: client_id
      kind: password
      label: Client ID
    - name: client_secret
      kind: password
    - name: refresh_token
      kind: password
    - name: start_date
      kind: date_iso8601
      description: Determines how much historical data will be extracted. Please be
        aware that the larger the time period and amount of data, the longer the initial
        extraction can be expected to take.
    - name: is_sandbox
      kind: boolean
      value: false
      description: Use Quickbooks Sandbox
    - name: select_fields_by_default
      kind: boolean
      value: true
      description: Select by default any new fields discovered in Quickbooks objects
    - name: state_message_threshold
      kind: integer
      value: 1000
      description: Generate a STATE message every N records
    - name: max_workers
      kind: integer
      value: 8
      label: Maximum number of threads to use
k
@edgar_ramirez_mondragon do you mean add the capabilities in the .yaml file under plugins: extractors, or under environments: config: plugins: extractors… or elsewhere entirely?
e
@kathryn_cowie the first one
k
the 1st change did not resolve it, but the second fix did! Thank you; now I see my output.😄 Going forward, should I plan to include capabilities and settings for taps I’m using?
meltano.yml
e
I'm glad it worked @kathryn_cowie!
Going forward, should I plan to include capabilities and settings for taps I’m using?
You shouldn't need to, unless you're adding custom taps. In this particular case, it is a bug in the upstream tap-quickbooks definition: https://gitlab.com/meltano/meltano/-/issues/3512
k
ok, good to know
Open in Slack
PreviousNext
Powered by