AF
HomeTagSubmit NotesAsk AnythingLoginSubscribe Us
AF
1. Feel Free to ask and submit anything on Anyforum.in and get satisfactory answer
2. Registration is not compulsory, you can directly login via google or facebook
3. Our Experts are looking for yours ?.



web-service-netsuite: How to get data from report in netsuite using webservices request?

Hi,

I want to get data from reports--->sales--->Sales by Item Summary in netsuite.Help me how to do this?which type of record i have to request?

web-service x 19
netsuite x 18
Posted On : 2014-09-02 12:25:33.0
profile veera - anyforum.in veera
3220
up-rate
3
down-rate

Answers


You can monitor Web services processing in a NetSuite account by Using the Web Services Usage Log or by Creating Integration Reports. Only administrators can access the Web Services Usage Log. Assigning the Web Services permission to a role does not provide access to this log. Only administrator access is supported because of the security issues that could arise from allowing other users to access this log and potentially see data that they do not have permission to see.

In addition to the Web Services Usage Log, you can also monitor Web services processing by
creating the following types of integration reports:

1. Integration and Automation Usage Summary by Job
2. Integration and Automation Usage Summary by Record Type

Important: The Integration permission is required to view these reports. To enable this permission, administrators must go to Setup > Users/Roles > Manage Roles.

Click Customize next to the appropriate role. On the Permissions tab, click Reports. In the Permissions drop-down list, select Integration and click Add.

Both of these reports provide details on type of operations used (for example, add, addList,
delete), who performed an operation, and the time an operation was performed.

Web Services Integration reports are also useful for administrators who need to diagnose and troubleshoot issues. Note that each report can be customized to display only the desired information. To customize a report, click Customize next to the desired report and then modify the report as desired.

If an integration report is timing out, it is recommended that you customize the report by adding filters so the report returns fewer results. See Filtering Integration Report Data.

1. Integration and Automation Usage Summary by Job:
---------------------------------------------------------------------------------------------
This report can be used for performance statistics. It shows the duration of each Web services processing job, the number of records modified in each job, the number of successful versus failed record modifications for each job, and the number of records queried for each job.

Any related SOAP files are stored in View links in the reports Request Doc and Response Doc columns. Be aware that NetSuite purges SOAP files every 30 days. To view the Integration and Automation Usage Summary by Job report:
Go to Reports > Integration > Integration and Automation Usage Summary by Job.

A message appears indicating that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.

2. Integration and Automation Usage Summary by Record Type:
---------------------------------------------------------------------------------------------------
This report lists the record types modified by Web services processing, and the number of records added, updated, deleted, and queried for each record type. To view the Integration and Automation Usage Summary by Record Type report:
Go to Reports > Integration > Integration and Automation Usage Summary by Record Type.

A message appears indicating that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.

Filtering Integration Report Data:
========================================
You can customize integration reports to run faster, by adding filters that limit the returned results. For example, you could limit a report to return only jobs with start dates that fall into a specified date range.

To filter an integration report by start date:
---------------------------------------------------------------------------
1. Go to Reports > Integration > Integration and Automation Usage Summary by Job >
Customize or Reports > Integration > Integration and Automation Usage Summary by
Record Type > Customize.
2. Click Filters.
3. In the Search Fields box, enter Start Date and click the Search button. The Actual Job Start Date and Start Date fields are listed.
4. Click Start Date. This field is added to the Choose Filters pane.
5. In the Choose Filters pane:
a. Set Filter to between.
b. Set Date Range to custom.
c. In the From and To fields, enter dates in {mm/dd/yyyy} format.
d. Click Done.
6. Click Save.

Posted On : 2014-09-02 15:02:17
Satisfied : 1 Yes  0 No
profile Rishi Kumar - anyforum.in Rishi Kumar
523188241268
Reply This Thread
up-rate
3
down-rate
Comments
thanks for your reply.my question is i´m having sales order report conatins item,desc,qty,total revenue field.i need to get these fields to my application.how to do this integration??is it possible can we get data from report like standard objects???
profile veera - anyforum.in veera
32  2  0
Posted On :2014-09-02 15:10:36.0
Leave a Comment

getSelectValue is used to retrieve valid values for a given recordRef field where the referenced record type is not yet exposed in the Web services API or when the logged in role does not have permission to the instances of the record type.

GetSelectValue Overview:
-----------------------------------------------------
The following figure shows the UI equivalent of a RecordRef field and a list of select values for this field. You can use getSelectValue to return the entire list of values or just a subset of values.

getSelectValue- NetSuite

Running getSelectValue against records that are created from other records may result in an INSUFFICIENT_PERMISSION error. For example, item fulfillment records are created from sales orders, so to avoid this error, you may need to run getSelectValue against the related sales order or item record instead of the item fulfillment itself.


Following java sample code shows how get select values for the Item field that appears on the Item sublist of a Sales Order record.

GetSelectFilterByFieldValueList myFilterByList = new GetSelectFilterByFieldValueList(new
GetSelectFilterByFieldValue[]{new GetSelectFilterByFieldValue(null,"entity","8")});
GetSelectValueFieldDescription myGSVField = new GetSelectValueFieldDescription(RecordType.salesOrder,
null, "itemList", "item", null, null, myFilterByList);
BaseRef[] br = c.getSelectValue(myGSVField);

Output-getSelectValue-SalesOrder- NetSuite

Posted On : 2014-09-03 01:09:52
Satisfied : 1 Yes  0 No
profile Rishi Kumar - anyforum.in Rishi Kumar
523188241268
Reply This Thread
up-rate
3
down-rate



Post Answer
Please Login First to Post Answer: Login login with facebook - anyforum.in