Dear Friends at the Forum,
I've been assigned the task to download the Trial Balance sheet per month to populate a data warehouse schema in our company's server. So far, the solution I've been using is downloading the Trial Balance report into a .csv file and then inserting these records into the proper tables. I figure that there must be an alternate solution to do this task more automatically via WebServices, but I'm not sure what Operation will get me the trial balance records.
The SuiteTalk Platform guide mentions a getSelectValue operation, so I tested it with the account_balanceSheet record type. Is this the correct operation/record for getting the Trial Balance values? Anyway, I get an INSUFFICIENT_PERMISSION error response, even though I logged in as Administrator.
Here is my request:
<?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:enc="http://schemas.xmlsoap.org/soap/encoding" > <soap:Body> <platformMsgs:getSelectValue xmlns:platformMsgs="urn:messages_2008_2.platform.webservices.netsuite.com"> <platformMsgs:fieldName fieldType="account_balanceSheet" /> </platformMsgs:getSelectValue> </soap:Body> </soap:Envelope>
...and here is my response:<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> <platformMsgs:documentInfo xmlns:platformMsgs="urn:messages_2008_2.platform.webservices.netsuite.com"> <platformMsgs:nsId>WEBSERVICES_527739_01252009253158591806629265_be05556b408930</platformMsgs:nsId> </platformMsgs:documentInfo> </soapenv:Header> <soapenv:Body> <getSelectValueResponse xmlns="urn:messages_2008_2.platform.webservices.netsuite.com"> <platformCore:getSelectValueResult xmlns:platformCore="urn:core_2008_2.platform.webservices.netsuite.com"> <platformCore:status isSuccess="false"> <platformCore:statusDetail type="ERROR"> <platformCore:code>INSUFFICIENT_PERMISSION</platformCore:code> <platformCore:message>You do not have permissions to set a value for element balanceSheet due to one of the following reasons: 1) The field is read-only; 2) An associated feature is disabled; 3) The field is available either when a record is created or updated, but not in both cases.</platformCore:message> </platformCore:statusDetail> </platformCore:status> <platformCore:recordRefList/> </platformCore:getSelectValueResult> </getSelectValueResponse> </soapenv:Body> </soapenv:Envelope>
Your advise will be greatly appreciated,LuisAlmori BPO Services