List of funds related to a specific campaign

@Nikita Aleshka
yup, there's no fiter that can be used on the 2 fund lists API call, filter the result array is your best bet

@Nikita Aleshka
what is your total fund count?

@Nikita Aleshka
for now it should be fine. As 1 call to the NXT integration API's fund list has a 10000 records return limit. So up to 10000 fund records, you can get them all in 1 call, then filtering should be easy.

How are you making calls? power automate? or custom program coding, what language if custom.

filtering in power automate is rather easy and doesn't take a LOT of processing time using the Filter array action.

Every programming language also has strong filtering data array capability as well

@Nikita Aleshka
if you are using directly SKY API, you are limited to what it allows you to filter on to get data, no way around that.

You want to have more custom filter capability, then you will need to replicate the data somewhere else in interval that you can accept.

For example, I replicated most of my RE NXT and FE NXT data in an Azure SQL data warehouse on 4 hours interval. So I can query however I want against any data point.

You will have to figure out what you are trying to do and determine what is worth the time and effort to do. I will say that if you are simply trying to get a list of funds that are associated with a specific campaign, it is better to just make the SKY API call, get the array of JSON and then use Node.js's array filtering capability to filter on campaign property. But again, I don't know the full extend of what you are trying to do so maybe there are more details you need from SKY API.

@Nikita Aleshka
you can search Idea Bank and see if there's already one and vote on it or add one yourselves

@Nikita Aleshka
List v2 currently only support Action, I don't know when it will support others.

my get fund list took 5s and I have 5676 fund records. It's not as “heavy” as you think.