Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
4.0k views
in Technique[技术] by (71.8m points)

NetSuite Custom Search in Java

I'm new to Oracle NetSuite and I'm trying to do an integration in Java.

I'm using this code to made the customRequest:

TransactionSearchAdvanced search = new TransactionSearchAdvanced();
search.setSavedSearchScriptId("customsearch12345");
SearchResult response = client.callSearch(search);

That give me a response that I parsed to XML that look like this(I haven removed of filtered anything, just plain serialization of the data received):

<searchRow>
    <shippingAddressJoin>
        <zip>
            <searchValue>49601</searchValue>
        </zip>
    </shippingAddressJoin>
    <itemJoin>
        <internalId>
            <searchValue>
                <internalId>34274338</internalId>
            </searchValue>
        </internalId>
    </itemJoin>
    <basic>
        <tranId>
            <searchValue>XXXXXXX</searchValue>
        </tranId>
        <item>
            <searchValue>
                <internalId>34274338</internalId>
            </searchValue>
        </item>
        <shipMethod>
            <searchValue>
                <internalId>350424</internalId>
            </searchValue>
        </shipMethod>
        <location>
            <searchValue>
                <internalId>64</internalId>
            </searchValue>
        </location>
        <tranDate>
            <searchValue>1606809600000</searchValue>
        </tranDate>
        <type>
            <searchValue>_itemFulfillment</searchValue>
        </type>
    </basic>
</searchRow>

Now, as you can see the list does return to me the fields of my customSearch, but only returns the internalId of the value of the field, And for what I have found out, is because thats one of the limitations of the Netsuite. The question is, what service of the suite could I call in order to obtain the values with internalId that I got from the first request? I been poking around with the Netsuite services, even tried adding the filter TransactionSearchRowBasic() and TransactionSearchBasic() but so far, none has helped me.

Thanks.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...