Skip to content

feat(source-hubspot): Migrate deals_archived, forms, form_submissions, owners, owners_archived to low-code #58105

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
wants to merge 28 commits into
base: master
Choose a base branch
from

Conversation

tolik0
Copy link
Contributor

@tolik0 tolik0 commented Apr 16, 2025

What

Migrate deals_acrhived, forms, form_submissions, owners, owners_archived streams to low-code.

How

Review guide

User Impact

Can this PR be safely reverted and rolled back?

  • YES πŸ’š
  • NO ❌

Copy link

vercel bot commented Apr 16, 2025

The latest updates on your projects. Learn more about Vercel for Git β†—οΈŽ

Name Status Preview Comments Updated (UTC)
airbyte-docs βœ… Ready (Inspect) Visit Preview πŸ’¬ Add feedback May 9, 2025 6:12pm

@tolik0
Copy link
Contributor Author

tolik0 commented Apr 16, 2025

/format-fix

Format-fix job started... Check job output.

βœ… Changes applied successfully. (ea285f7)

@tolik0 tolik0 marked this pull request as ready for review April 17, 2025 11:17
@tolik0 tolik0 requested a review from a team as a code owner April 17, 2025 11:17
@tolik0 tolik0 changed the title feat(source-hubspot): Migrate deals_archived to low-code feat(source-hubspot): Migrate deals_archived, forms, form_submissions, owners, owners_archived to low-code Apr 18, 2025
Copy link
Contributor

@brianjlai brianjlai left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

looks good overall and the various custom transformers seem reasonable. Have you had a moment to run regression tests. Can give the final approval once we have a confirmed/analyzed run

@@ -1,654 +0,0 @@
{
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Shouldn't we also be removing all the other .json stream schemas that we are deleting?

@tolik0 tolik0 force-pushed the tolik0/source-hubspot/migrate-deals-archived branch from 9b02942 to 4e9234c Compare May 8, 2025 14:53
@tolik0
Copy link
Contributor Author

tolik0 commented May 8, 2025

/format-fix

Format-fix job started... Check job output.

βœ… Changes applied successfully. (08499aa)

Copy link
Contributor

github-actions bot commented May 8, 2025

source-hubspot Connector Test Results

346 tests   346 βœ…β€ƒβ€ƒ8m 25s ⏱️
  2 suites    0 πŸ’€
  2 files      0 ❌

Results for commit a125a2c.

♻️ This comment has been updated with latest results.

Copy link
Contributor

@brianjlai brianjlai left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

looks good for most streams, I did have one question about the query parameters for the forms stream and if we can potentially simplify the request since we now use the v3 endpoint, once we wrap up that discussion. then happy to give final approval

path: /marketing/v3/forms
request_parameters:
formTypes:
"['hubspot', 'captured', 'flow']"
Copy link
Contributor

@brianjlai brianjlai May 8, 2025

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Testing in Postman, does this result in an error when formatted as a string list? I had to format each formType=hubspot as a separate parameter. For example:
https://api.hubapi.com/marketing/v3/forms?limit=100&formTypes=captured&formTypes=hubspot&formTypes=flow

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This will be formatted as separate parameters: https://api.hubapi.com/marketing/v3/forms?formTypes=hubspot&formTypes=captured&formTypes=flow&

# TODO: consider migrating FormSubmissions stream to use `/v3` api version
# then uncomment the last 2 form types.
# "blog_comment",
# "all",
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

i see this was a comment from the python code, I wonder if we can add these params back. I can't tell if this comment is still relevant because it does look like we're now already using the /marketing/v3/forms endpoint now and this stream does not appear to interact w/ the FormSubmissions stream or v1 API in any way.

I did some experimentation and it seems like at the very least we can uncomment and include both blog_comment and all in query parameters. And I also tested on our own dataset and we may be able to simply specify formTypes=all to retrieve all forms. When I counted records I got the same amount for formTypes=all vs &formTypes=captured&formTypes=blog_comment&formTypes=hubspot&formTypes=flow

what do you think?

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I think it's safer to stick with a 1:1 migration for now to avoid any unexpected issues. I'll create an issue to further investigate this.

Copy link
Contributor

@brianjlai brianjlai May 8, 2025

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

okay yes and thank you for creating the issue. you are right just for simplicity we can retain the same behavior

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Copy link
Contributor

@brianjlai brianjlai left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

pending

but approving to not block releasing once the above are complete

@tolik0
Copy link
Contributor Author

tolik0 commented May 9, 2025

/format-fix

Format-fix job started... Check job output.

βœ… Changes applied successfully. (d360e9f)

@tolik0
Copy link
Contributor Author

tolik0 commented May 9, 2025

/format-fix

Format-fix job started... Check job output.

βœ… Changes applied successfully. (79a334b)

@tolik0
Copy link
Contributor Author

tolik0 commented May 9, 2025

paginator:
$ref: "#/definitions/cursor_paginator"
record_selector:
type: RecordSelector
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

wanted to note that when @darynaishchenko was implementing goals, she noticed that we aren't properly normalizing the properties values back to their expected types. She added a custom normalization strategy for this that I think we'll need to incorporate into some of these streams with dynamic properties. See here:

https://github.com/airbytehq/airbyte/pull/59727/files#diff-1b47d519451dbf69102c8e716c20ddbbc3049b92cde345bdca1a49757276583eR924-R928

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants