airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
15.97k stars 4.1k forks source link

New Source: Salesforce Pardot #2978

Closed sherifnada closed 1 year ago

sherifnada commented 3 years ago

Tell us about the new integration you’d like to have

https://www.pardot.com/

Describe the context around this new integration

Describe the alternative you are considering or using

What are you considering doing if you don’t have this integration through Airbyte?

┆Issue is synchronized with this Asana task by Unito

po3na4skld commented 3 years ago

Integration Vetting

Webhook-based?

No

Available authentication modes

OAuth, Bearer token

Connecting to the data source

All requests to the API must:

Creating an account

The Essentials Edition does not allow for API access. You will only be able to integrate with apps available in our AppExchange for the Essentials edition. You can find more info here To access the API, you'll need to upgrade your edition to Professional or Enterprise. @sherifnada

Ability to register 14-days trial account, pricing plans:

Screenshot 2021-06-10 at 15 50 50

How to populate the account with data?

Can it be done entirely through the API?

Yes

Will it require some work through the UI? If so, what is required?

No

Will it require performing some paid action like running an Ad campaign? If so, please note the action needed, estimated cost, and estimated effort in hours. If a task will take more than 4 hours, break it down into smaller tasks each of which take no more than 4 hours

No

Do you need any actions from Airbyte to populate the account with data?

There are basic samples for introduction purposes

Available streams for sync

All endpoints have sync read method and XML as responses

Accounts Campaigns Custom Fields Custom Redirects Dynamic Content Emails Email Clicks Email Templates Forms Lifecycle History Lifecycle Stage Lists List Membership Opportunity Prospects Prospect Account Tags TagObjects Users Visitors Visitor Activities Visits

Do any streams support incremental sync?

almost all streams can be queried by created_before, created_after, updated_before, updated_after fields. almost all streams have sort orders by date or id

Those that cannot support incremental sync:

Preparation scope & blockers

Buy an account as trial lasts only for 14 days

To access the API, you'll need to upgrade your edition to Professional or Enterprise: https://www.salesforce.com/editions-pricing/sales-and-service-cloud.

Other information/blockers

Source also supports OAuth2.0, has three vesrions of API: 3, 4, 5. The newer the api the less endpoints there are API interface written in XML

Error codes description

sherifnada commented 3 years ago

@po3na4skld this page says professional pricing is $175/mo -- where did you get the screenshot above?

po3na4skld commented 3 years ago

@po3na4skld this page says professional pricing is $175/mo -- where did you get the screenshot above?

@sherifnada when I had registered and logged in from this https://www.pardot.com/ link, they asked me to buy a plan and gave this pricing plan. Also pricing plans from your link are the same with those I've sent. Maybe we have different pricing due to the region we live in

Screenshot 2021-06-11 at 10 22 59
po3na4skld commented 3 years ago

@sherifnada to login into pardot dashboard, you need to open lastpass and go to the url that specified there, pass credentials and login, they can ask you for a mobile number but you are open to skip this step.

kyle-cheung commented 3 years ago

+1! Would love to see this source

kyle-cheung commented 3 years ago

any update on this? would be huge in my org and im sure for many others as well!

dubravcik commented 2 years ago

Hi, this looks as it was merged and released half a year ago but I can't access docs https://docs.airbyte.com/integrations/sources/pardot mentioned in the release log https://docs.airbyte.com/project-overview/changelog/connectors/, nor I don't see it in Airbyte as a source. I am using 0.36.6

igrankova commented 2 years ago

@dubravcik I see the issue with sandbox is blocked on Salesforce side: https://github.com/airbytehq/airbyte/issues/7276 They provide a Pardot provisioned Salesforce Developer Org only to partners. We still in progress with the partner program.

marcosmarxm commented 1 year ago

Closed by https://github.com/airbytehq/airbyte/pull/7091