<@U5TF1GQ20> Hello Battk, I need you help with t...
# suitetalkapi
a
@battk Hello Battk, I need you help with the following question. In NetSuite, my Customer has contacts that bound with Customers. But, during the sync process our connector doesn't receive contacts. In NetSuite, I opened SOAP logs and saw the connector sent a request to receive contacts, but NetSuite doesn't return them. What are the possible reasons and what else should I pay attention to?
b
too high level, i dont even know what operation you attempted
give much more detail
a
1. Created a Customer 2. Created a Contact (Contacts journal) 3. In the created contact, I added the Customer. 4. Opened the Customer and see the Contact inside the Customer. Then, our application started the sync process. The connector sent the following request: 164124.547 [main] INFO c.y.i.a.s.n.s.api.LogEntityService - request: <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <soapenv:Header> <ns1:searchPreferences xmlns:ns1="urn:messages.platform.webservices.netsuite.com" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0"> <ns2:bodyFieldsOnly xmlns:ns2="urn:messages_2020_1.platform.webservices.netsuite.com">false</ns2:bodyFieldsOnly> <ns3:returnSearchColumns xmlns:ns3="urn:messages_2020_1.platform.webservices.netsuite.com">false</ns3:returnSearchColumns> <ns4:pageSize xmlns:ns4="urn:messages_2020_1.platform.webservices.netsuite.com">1000</ns4:pageSize> </ns1:searchPreferences> <ns5:tokenPassport xmlns:ns5="urn:messages_2020_1.platform.webservices.netsuite.com" soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0"> <ns6:account xmlns:ns6="urn:core_2020_1.platform.webservices.netsuite.com"></ns6:account> <ns7:consumerKey xmlns:ns7="urn:core_2020_1.platform.webservices.netsuite.com"></ns7:consumerKey> <ns8:token xmlns:ns8="urn:core_2020_1.platform.webservices.netsuite.com"></ns8:token> <ns9:nonce xmlns:ns9="urn:core_2020_1.platform.webservices.netsuite.com"></ns9:nonce> <ns10:timestamp xmlns:ns10="urn:core_2020_1.platform.webservices.netsuite.com"></ns10:timestamp> <ns11:signature xmlns:ns11="urn:core_2020_1.platform.webservices.netsuite.com" algorithm="HMAC_SHA256"></ns11:signature> </ns5:tokenPassport> </soapenv:Header> <soapenv:Body> <search xmlns="urn:messages_2020_1.platform.webservices.netsuite.com"> <searchRecord xmlns:ns12="urn:relationships_2020_1.lists.webservices.netsuite.com" xsi:type="ns12:ContactSearch"> <ns12:basic xmlns:ns13="urn:common_2020_1.platform.webservices.netsuite.com" xsi:type="ns13:ContactSearchBasic"> <ns13:company xmlns:ns14="urn:core_2020_1.platform.webservices.netsuite.com" operator="anyOf" xsi:type="ns14:SearchMultiSelectField"> <ns14:searchValue externalId="" internalId="37868168" type="customer" xsi:type="ns14:RecordRef"> <ns14:name xsi:type="xsd:string"/> </ns14:searchValue> </ns13:company> </ns12:basic> </searchRecord> </search> </soapenv:Body> </soapenv:Envelope>
b
that search should give you contacts whose company field is set to the customer with internal id 37868168
if you instead want the contact role relationship, you will need to use an advanced search and use the customer join
i advise making the search in the ui first if you want to see the difference
a
battk  [10:48 AM] that search should give you contacts whose company field is set to the customer with internal id 37868168 <<< Yes, you are right. Contacts have the id 37868168. But it strange NetSuite doesn't return them
b
what does the contact record you are trying to search for look like
a
message has been deleted
b
thats not the contact record, that looks like the customer record
specifically the contacts sublist, which is not actually related to the company filter you are using
I heavily recommend you make the search in the ui first, so you can see the behavior of the company filter vs the company/customer join filters
a
I understood. Thank you a lot!
@battk, could you give me a link to the search contacts page?
I will try to check
b
a
thank you
@battk What type of filter I can use to find payments?
For example by period
I found
b
I wouldnt expect you to be able to do it from a contact search
contacts dont make payments
a
Sorry, it is a separate search. I didn't mentione it