Seeking some help using the Marketo connector in ADF v2 with a Marketo
I am unable to do any of the following:
Connection with Marketo s successful in Linked Service but unable to load tables.
Getting a list of tables when creating a new dataset
Manually typing in a table name such as "leads" and trying to get a preview of the data within the dataset
Using a custom SQL query in a Copy Activity and trying to get a preview of the data. For example, "select id from Leads"
All the above actions result in the same error:
ERROR [HY000] [Microsoft][Marketo] (20) Error while attempting to use REST API: Opportunity API disabled Unknown Error Code . Activity ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
Is there any other way of copy data from Marketo to Azure SQL Database?
.png)