Has anyone successfully overridden the default fie...
# suitecommercew
wes_w
05/14/2024, 4:44 PMHas anyone successfully overridden the default field set for matrix child items?
I created a new field set called
matrixcache/api/items/bulk?matrixchilditems_fieldset=matrixcache&fields=itemimages_detail,isinstock,matrixchilditems_detail,itemoptions_detail,urlcomponent,commercecategorymatrixchilditemss
Steve Goldberg
05/14/2024, 5:11 PMI'm not an expert on that parameter but my guess is that it is because it only acts as an overrider when you specify a field set that includes a matrix child items field set. If you specify the matrixchilditems_detail field set as a field, for example, in your request then the API is going to retrieve that.
Steve Goldberg
05/14/2024, 5:13 PMSo, for example, my details field set has the matrixchilditems_detail field set in it. If I wanted to create a request that used the details field set but not the matrixchilditems_detail field set, then that's when I would use that parameter.
So, something like this, perhaps:
Copy code
/api/items?fieldset=details&matrixchilditems_fieldset=matrixcachew
wes_w
05/14/2024, 5:14 PMlet me try that
wes_w
05/14/2024, 5:17 PMI sure wish there was better documentation on this
s
Steve Goldberg
05/14/2024, 5:19 PMFirstly, did that work as how I described it?
Steve Goldberg
05/14/2024, 5:19 PMSecondly, I can request an improvement on the documentation
w
wes_w
05/14/2024, 5:29 PMnot sure yet
wes_w
05/14/2024, 6:43 PMok this worked, but the details fieldset has more fields than I need, so it is still too big to process
wes_w
05/14/2024, 6:44 PMcan I just get specific fields, but use the matrixchilditems_fieldset with it?
s
Steve Goldberg
05/15/2024, 9:30 AMWell, I think you would need to create both a new field set and a child matrixchilditems fieldset and then do it that way
w
wes_w
05/15/2024, 1:25 PMYeah that's what I ended up doing last night, but it's still too much data for my Map/Reduce script. I'm going to have to re-work the MR script.
s
Steve Goldberg
05/15/2024, 1:34 PMHave you considered just setting up a product feed? You could just create a generic CSV file of the data you need https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_1535554720.html
6 Views