user10648298 Newbie

a few questions: 1) how long do job results stay available for? 2) what units are used in the estimated remaining time? it doesn't seem to be seconds or milliseconds. 3) how do you cancel an asynchronous job? i tried passing a recordRef to CancelAsync but that didn't do anything. 4) is there any reason why a basic async…

ODBC is really good for very large queries (like all of a given record type). I believe you have to have Advanced Reporting and Analytics on in your account. If so you can download the driver and write SQL queries against the underlying data tables using Excel Web Query or Crystal Reports or anything that uses ODBC. I do…

I used PHP5, and I forget exactly which apache. You need to have https enabled for PHP. What is the error you are seeing? -John

Go to NetSuite SuiteSource http://sourceforge.net/project/showfiles.php?group_id=180270&package_id=208580 there is an example of logging in and searching for customers by zip code (and showing them on Google Maps like every WebServices demo ever made). It extends NuSoap. The main challenge is all the abstraction which no…

I'd have to know more about the failure to tell you. I believe apache is responsible for loading both the PHP engine and the SSL engine - so make sure you have modules for both configured correctly. Can you run any php app from 2.2? Can you write a PHP page that connects to…

If you are using .NET then the SOAP should be generated correctly. I bet the namespaces are there, but .NET may be a little more clever about reusing them, ie not redeclaring them. You can use MindReef SoapScope to submit hand written SOAP requests to NetSuite. You can also use a combination of TCPMon and STunnel, but that…

What are you using to generate the SOAP in your request? Have you had any luck tried Axis and checked if there are any differences in the SOAP? -John

http://www.netsuite.com/portal/developers/resources/suitetalk.shtml -John

cfouts - does this happen every time with this operation, or intermittently? -John

Make sure you can edit the field the Insufficient Permission Error refers to in the UI. cfouts, really great sample code. Just as an FYI if you don't need to do any joins you can search on a SearchBasic. EG. //ts.setBasic(tsb); SearchResult result = port.search(tsb); // was port.search(ts); -John

I'd have to see your SOAP to see definitively, but I think you have replaceAll set to F on the machine, and you don't specify "line" (line wasn't in the 2_0 schema, but is in the 2_5). Thus when you submit an SO for update with all of those line items, and with replaceAll = F, it assumes they are new. See the release notes…

niallp, Partners are not yet supported with Attach. -John

For the most part it is a reserved attrbute that we use internally, and may use more in the future. You can safely ignore it for now. -John

UNEXPECTED_ERROR can pretty much always be considered an error on our side. You should either be getting back a specific error, or your call should work. Our support staff can lookup these errors, but they would be of no use to you. -John

No updates yet. I wouldn't worry about the age, it's a fairly simple utility and we haven't changed anything that would break Axis 1.4. Is there some specific functionality you are looking for? -John

Please file a case on this one. Your code looks correct. -John

You should be getting some response. What does the SOAP you are sending look like? You can tell by calling --- print_r($_POST); --- after your searchBasic() call. Also, what does print_r($result) look like? -John

Shanon, It is being looked at in development. -John

He's right, you would not see this problem with async, and that is a great solution if it fits your use case. If you have to use sync, a good idea is to funnel/wrap all your NetSuite calls and catch this exception (AxisFault, getMessage() contains Connection Reset). Simply running the command again will most likely work,…

Please repost to Web Site / E-Commerce https://usergroup.netsuite.com/users/forumdisplay.php?f=20 This is the forum for the Web Services API (SOAP / Partner Integration, that sort of thing). Good luck, -John

Shanon, Please file a case, an issue has already been created for this. -John

What NetSuite components are missing for an integration with Exchange? Looking at the enhancement mentioned above, it implies that NetSuite should connect directly to an Exchange Server. That seems problematic as Exchange Servers are generally behind the firewall. Exchange looks like it has some programmability features (…

Can you perform a similar search in the UI using Advanced Search? If so what are the criteria/operator/value sets? -John

Try it without setting the ACCOUNT cookie. Failing that, enter a case with support - it's very helpful if you can capture the SOAP. -John

2 batches of 50 will take essentially no less time than 1 batch of 100. Batches of 20 probably provide the best balance. Setting your Axis timeout longer is a good idea, but may not solve this problem. Do you have exact timing data on when you see this connection reset (ie is it always after exactly N minutes?) Also, does…

This will be resolved by a feature in the first release of 2008 - more details to follow as we get closer to release date. -John

Before nlapiStringToXML, you call response.getCode(), do you know what that returns? Also, you may want to post to the SuiteScript forum, since this is generally for the NetSuite WebServices API. -John

Interesting application. Webservices is the way to go in this case, ODBC access is read-only. What will probably help you the most is searching by lastModified and the getDeleted() operation. Once you have downloaded the full set of records once, subsequently search where lastModifiedDate (or creationDate) > the last time…

Do you search with BodyFieldsOnly=true? It's a preference that can be set globally (Setup->Integration->Web Services) or in the SoapHeader. This type of search is several times faster than a BodyFieldsOnly=false search. How often are you searching for all your customers and how many do you have? I'd be interested in…

Does an item search on parent give you what you want? ItemSearchBasic isb = new ItemSearchBasic(); isb.setParent(...); port.search(isb); -John