How to add additional returncols for an Invoked API from Factory Track to M3.

Legacy Contributor

Hi Members,

When there is an MI invoke from any Factory Track form (M3ShipmentLoading.mobi), there seems to be an API Call from FT Form (Shipment Loading) (in Current Transaction WorkBench).

/m3api-rest/v2/execute/DRS100MI/LstShipment;m3user=21019230;maxrecs=0;returncols=CLOS,CONN,CSTL,DSDT,DSHM,DSTL,FWNO,LODO,MMDL,NBLL,NBLP,NBPL,NBRP,ROUT,SILO
?SDES=494&CONN=&FCSH=&TCSH=&FCSL=&TCSL=&ROUT=&TRCA=&SILO=&1DDT=20190926&2DDT=20210518&LODO=&DLOS=1

Where is the returncols defined ?

As from M3 LstShipment API, I can find multiple field outputs when I invoke the API from MDP MI repository.
Will I be able to add additional Field say for ex TRCA in returncols field and how can it be done ?

Please guide.

Thanks & regards,
Ajit Shinde

Legacy Contributor

Hi,

I'm not that familiar with how Factory track is delivered. If you have access to the source you can add more returncols as long as they are part of the APIs output. In general you should always set returncols so that the API only returns the columns that you are interested in. That way you'll not waste bandwidth and the call will be faster.

If they have a way to configure that in the application itself I don't know. I'll see if I can get a hold of someone that can answer your question.