Hey everyone :wave: hope you're doing well! I had...
# troubleshooting
s
Hey everyone 👋 hope you're doing well! I had a question regarding selections: When I select data in my tap (tap-hubspot), I can see all the properties offered:
Copy code
select:
      - line_items.*
BUT, when I try to access individual nested properties (in the
properties
), I'm not capable of only selecting 1.
Copy code
select:
      # - line_items.*
      - line_items.properties.hs_url
Will give
Copy code
Enabled patterns:
        line_items.properties.hs_url

Selected attributes:
        [automatic] line_items.id
        [automatic] line_items.updatedAt
(Not hs_url). Is this normal? How can I select individual properties? Thanks, and have a great day!
e
Maybe this would work:
Copy code
select:
      - line_items.properties
      - "!line_items.properties.*"
      - line_items.properties.hs_url
(If that works it's a sign that we really need to do https://github.com/meltano/meltano/issues/3024 😅)
s
Thanks @Edgar Ramírez (Arch.dev), I'll look into it 👋
Copy code
- line_items.id
      - line_items.properties
      - line_items.properties.*
      - line_items.properties.hs_url
      - "!line_items.properties.*"
Sadly this has not helped 😞 But the link you provided still seems relevant to this problematic
👀 1
e
You probably need to put the exclusion rule before `line_items.properties.hs_url`:
Copy code
- line_items.id
      - line_items.properties
      - "!line_items.properties.*"
      - line_items.properties.hs_url
c
Hi @Stéphane Burwash have you solved this problem? i’m facing the same.
s
Hey @claudio_cianciulli sorry, not I sort of just gave up 😓 if you find any new angle please let me know