It's not returning all the fields from the view even though they are all specified in the plugin. I am wanting to get all the P1 to P10 prices - some of them might be 0 but I still want it returned as 0. I also want Picture (which might be null), LastSavedDateTime and a few other fields also.
This is what is getting returned via Swagger UI.
- Code: Select all
{
"InventoryID": "cfce627bfbc048a3ba72",
"PartNo": "00-2312",
"Description": "BALL BEARING FOR",
"ForwardPriceDate": "2031-07-01T14:41:49.1030000",
"CurrentPriceDate": "2021-07-01T14:41:49.1030000",
"P1": 10.32,
"P2": 9.38,
"P3": 8.92,
"P4": 8.45,
"P5": 7.98,
"PhysicalItem": true,
"Brand": "Default - No Category",
"Category": "Default - No Category",
"Range": "Default - No Category",
"TBA": "Default - No Category",
"Packaging": "Default - No Category"
},