We're trying to export data points via the API about the subscriptions. Currently, it looks like it's not an additional column but a totally new call as we have to request for every single deal id if it's connected to a subscription or not. 

Can it be we're using it wrong cause it feels a bit wrong and inefficient to run it that way? First, we thought it another column that we can request and we will find a true/false in that column to run an analysis on this but currently it's not possible. 

We're talking about 14k deals that would have to be checked with every call if there is a subscription or not. 

The metrics that I would want to requests are:

Subscription yes / no

Amount

Cycles

Start Date

End Date

Total revenue earned

 

Any experience or advice?