Hi all, wondering if anyone can help me with a pricing search? I can't seem to find good documentation on it and for some reason this search isn't pulling up any results.

var itemSearch = search.create({
                                            type: search.Type.PRICING,
                                            filters: [
                                                ["internalid", "anyof", itemToValidate.internalId],
                                                "AND",
                                                ["pricelevel", "anyof", "6"]
                                            ],
                                            columns: [{
                                                name: 'internalid'
                                            }, {
                                                name: 'unitprice'
                                            }]
                                        });

Create the search in the UI, then export to script with the chrome extension.

I tried 😞 Pricing search exports aren't supported

let itemSearch = search.create({type: search.Type.PRICING, filters: [], columns: ['internalid', 'unitprice']}).run().getRange(0,100).map(s => s.toJSON())

that as an example does indeed run and has results

Yes, itemToValidate.internalId is pulling the correct item id.

is price level 6 filled out on that item? It will have no results if it isnt

Yup, it's filled out...

There is nothing inherently wrong with the search, I just ran that search that I pasted in the console, and it worked fine

Just figured it out! It needs to be iteminternalid.

yeah the internalid should be

1,2,3,4,5,6,etc

Because it's a pricing search, internalid pulls up the price level, not the item.