I have a API call for Prime InventoryDetails in my SSIS ETL package, the endpoint is as "~/webacs/api/v4/data/InventoryDetails?.full=true&.maxResults=500&.firstResult=0". It returns all attributes for InventoryDetails. I don't need the full attributes, just some of them. How can I filter out some attributes in this API call?
The disadvantage for ".full=true" to return all attributes is the response string is too big and will finally cause timeout after some loops calling.
Any advice is helpful. Thanks.
