How can I fetch Trial balance reports via SOAP API...
# suitetalkapiv
VK101
11/12/2020, 2:37 AMHow can I fetch Trial balance reports via SOAP API ?
b
battk
11/12/2020, 3:21 AMreports are for the ui, there is no equivalent via api
battk
11/12/2020, 3:22 AMbest you can do is recreate the data you want using a saved search
v
VK101
11/12/2020, 3:26 AM@battk - I have never used saved search before. What I want here is to pull account balance data via Soap api monthly !!
b
battk
11/12/2020, 3:33 AMyou probably want to get started learning about searches
battk
11/12/2020, 3:33 AMyou will probably end up doing transaction searches
v
VK101
11/12/2020, 4:40 AMFor saved search do we need to first go and create a saved search in UI ? And then fetch it via Soap Api with its internal id?
b
battk
11/12/2020, 7:50 AMTransactionSearchAdvanced allows you to build your own search
battk
11/12/2020, 7:50 AMor reference an existing one
v
VK101
11/12/2020, 11:20 PMSo you mean I don't need to do anything in NetSuite UI ? I can directly create a savedsearch with Api ? If you have any experience in doing so, pls help me... I've been reading through transactionsearchadvanced but not able to create any soap api request successfully or if you have any tutorial that can help me pls let me know
b
battk
11/13/2020, 4:28 AMwhat have you tried? Functionality of advanced searches is explained in Advanced Searches in SOAP Web Services
battk
11/13/2020, 4:29 AMi recommended doing the search first in the ui since you will probably have an easier time seeing the data you are working with
2 Views