Is there a way to speed up the Email Event get campaign IDs API?
SOLVE
Hi,
I'm trying to retrieve the email event (campaign) data from Hubspot into our database. I'm trying to get the unique campaign ID using the following API.
Both of these API seems to take a very long time to run and they seem trying to retrieve over a million of records...Is there a way to make any of these two API run faster?
My goal is to get the unique campaign IDs using either of the menioned API and then combine them with with another API to get the detailed data about each campaign.
Based on your response and the fact that I wasn't able to get any of these two APIs to finish during my testing (I stopped them after a few hours), I finally realized that there must have something to do with stop indicator. I use ZappySys JSON Source SSIS component to run these APIs. In the component, I set the Array Filter to $.campaign which is one level down from the parent. But, the hasMore indiciator is at the parent level. Therefore, when I use the default $.hasMore = false to stop the execution, it has no effect. I have to manually type in $.P_hasMore to resolve the issue (P_ indicate the parent level). Now, the API complete in an instant...just like you said.
Based on your response and the fact that I wasn't able to get any of these two APIs to finish during my testing (I stopped them after a few hours), I finally realized that there must have something to do with stop indicator. I use ZappySys JSON Source SSIS component to run these APIs. In the component, I set the Array Filter to $.campaign which is one level down from the parent. But, the hasMore indiciator is at the parent level. Therefore, when I use the default $.hasMore = false to stop the execution, it has no effect. I have to manually type in $.P_hasMore to resolve the issue (P_ indicate the parent level). Now, the API complete in an instant...just like you said.