Does anyone know how to filter down to a specific transaction based on document number when using the advanced transaction search API? Seems like the criteria I’m defining aren’t actually being applied to the search

what does the request look like

we’re working off of a variation of the netsuite-sdk-py python library, so we’re actually a few layers of abstraction away from the SOAP. We’ve tried both:

{
    'criteria': {
        'tranId': {
            'searchValue': 'JE123',
            'operator': 'is'
        }
    },
    'columns': None,
    'savedSearchId': None,
    'savedSearchScriptId': None
}

and also

{
    'criteria': None,
    'columns': None,
    'savedSearchId': None,
    'savedSearchScriptId': None,
    'tranId': {
        'searchValue': 'JE123',
        'operator': 'is'
    }
}

but the request just returns the first 100 transactions

ok this is helpful, so it seems like those criteria are not even making it into the request!

<soap-env:Body>
    <ns0:search xmlns:ns0="urn:messages_2019_1.platform.webservices.netsuite.com">
        <ns0:searchRecord xsi:type="ns1:TransactionSearchAdvanced" xmlns:ns1="urn:<http://sales_2019_1.transactions.webservices.netsuite.com|sales_2019_1.transactions.webservices.netsuite.com>" xmlns:xsi="<http://www.w3.org/2001/XMLSchema-instance>"/>
    </ns0:search>
</soap-env:Body>

fair chance you are using your library wrong

Interesting… thanks for the help @battk this is my first time working with the NS API and the first time in 10 years that I deal with SOAP so this is very helpful already. Do you happen to know what a correctly formatted XML request should look llike for something like this?