I am looking at sage 50 sdata webservice I am able to list all bank accounts and I am able to list customer bank account ect but I can not figure out how to list the activity of one of the bank accounts say the the cash account. I am hitting the following endpoint that list only bank accounts "http://localhost:5493/sdata/accounts50/GCRM/-/bankAccountOpCo" I have looked through all the available adapters so I think it must be a query made to the webservice that gives the list of activity for an individual bank account, can anyone adivise
how to query bank activity with sage sdata service
418 Views Asked by Artful_dodger At
1
There are 1 best solutions below
Related Questions in PHP
- php Variable name must change in for loop
- register_shutdown_function is not getting called
- Query returning zero rows despite entries existing
- Retrieving *number* pages by page id
- Automatically closing tags in form input?
- How to resize images with PHP PARSE SDK
- how to send email from localhost using codeigniter?
- Mariadb max Error while sending QUERY packet PID
- Multiusers login redirect different page in php
- Imaginary folder when I use "DirectoryIterator" in PHP?
- CodeIgniter + XDebug: debug only working in the main controller, index() function
- PHP script timeout when I use sleep()
- posting javascript populated form to another php page
- AJAX PHP - Reload div after submit
- PHP : How can I check Array in array?
Related Questions in WEB-SERVICES
- couldn't copy pdb file to another directory while consuming wcf web service
- .net rest service with JSON string and consumed with java client
- How to send Rest GET request that contains "#" value in url parameters?
- Looking the Method that MANUALLY INSTALL PHP on OSX Yosemite
- How to use @queryparam when using array in Java
- How to accept cookies when using a webservice - Android?
- zend soap server reading xml attributes
- Web Service Error path property must set before calling the send method
- Error with kSOAP2
- JAX-RS service response is returning double fields without decimal places
- How can I call a ASP.Net webservice using AJAX without calling controller
- Generate clients for multiple WSDL files and place it in different package through Spring Gradle
- File upload in AXIS2 webservice
- How to route by call method in proxy with WSO2?
- fetch data from web service to dataset in Delphi
Related Questions in SAGE-LINE-50
- SData Integration with Sage Accounts 50, 2010 release
- Error with app accessing Sage Line 50 data via ODBC
- how to query bank activity with sage sdata service
- how to query multiple endpoints with curl on sdata web serivce
- Integrate Sage Line 50 with windows application
- Sage Line 50 ODBC issues with Python 3
- Integrating with Sage Financial Software
- Subquery not working with Access linked tables
- Is it possible to connect to a microsoft database like sage from a Linux server?
- Using access vba to pass the login via variables to automate the login to Sage Line 50 ver20
- How to access the product list from Sage Line 50?
- Pulling data from Sage Line 50 Cloud
- Connecting two web application through API using SDK
- I am trying to synchronise a Sage Line 50 Access database with Mysql via ODBC
- Where do I find the expenses data in Sage?
Related Questions in SDATA
- How to create a new contact in Saleslogix Infor CRM using DotNetSDataClient
- SData - SalesLogix
- SData Integration with Sage Accounts 50, 2010 release
- how to query bank activity with sage sdata service
- how to query multiple endpoints with curl on sdata web serivce
- JQuery Headers for internal AJAX call
- Sage 50 2014 SData issues
- Sage sdata web service issue
- DataTable with JS Source
- Sage Evolution website integration
- Sage 50 SData XML to JSON POST Request
- sData REST APIs for sage 100 ERP
- Sage 300 (accpac) SDATA Create Customer
- AccountKey in sData
- Sage50 SData POST to tradingaccountCustomerfeed
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Sage is like a plant and all plants need a seed in this case the seed or should I say table you need to search is tradingActivities it is the root of sage accounts it what accounts call the audit trail my suggestion is to look at the financials module and use the report builder to see how sage would generate the data you require because all data stems from here. You may want to try something like
localhost:5493/sdata/accounts50/GCRM/-/tradingActivities?where=accountReferance eq"1201"&format=jsonI hope this helps.