SX.e Api FetchWhere results

Nathalie Abel

Is there a way that the Api returns only the fields we need ?

ex: fetchwhere table  ordhdr: it returns for example, bill_city, bill_country, bill_state, etc. Is it possible to tell the api to return only the bill_city ? (From Postman)

 "bill_city": "XXX",

            "bill_country": "CA",

            "bill_name": "TEST ACCOUNT",

            "bill_state": "QC",

            "bill_zip": "ZZZ ZZZ",

            "branch_id": "",

            "cancel_flag": false,

            "carrier": "NC",

            "class": "SO",

            "co_num": "1   ",

            "cod_addr": [

Anthony Kapusinski

No you cannot include or exclude fields using the FetchWhere call.

I'm assuming you are referring to the FetchWhere call under Infor Distribution SX.e.  You should indicate that. This channel serves a much larger audience than just SX.e / CSD.