API Request Body - Select and Group By

allen-noakes

I'm creating a custom integration for our company using Workflow and API calls within that workflow. I'm making a call to SunSystems API trying to get back ledger lines, but would like to only select certain fields if possible.

API call is /api/businessobject/v1/{businessUnit}/ledger-lines/query-json

Setting parameters is no problem, but in the request body is it possible to only select fields I need instead of getting all of the fields back?

Here is my test request body.

{
"SELECT": ["baseAmount"],
"where": "accountCode = ('111510')",
"orderBy": [
"accountCode DESC"
]
}