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
- How to add the dynamic new rows from my registration form in my database?
- Issue in payment form gateway
- How to create a facet for WP gridbuilder that displays both parent and child custom fields?
- Function in anonymous Laravel Blade component
- How to change woocomerce or full wordpress currency with value from USD to AUD
- General questions about creating a custom theme Moodle CMS
- How to add logging to an abstract class in php
- error 500 on IIS FastCGI but no clue despite multiple error loggings activated
- Composer installation fails and reverts ./composer.json and ./composer.lock to original content
- How to isolate PHP apps from each other on a local machine(Windows or Linux)?
- Laravel: Using belongsToMany relationship with MongoDB
- window.location.href redirects but is causing problems on the webpage
- Key provided is shorter than 256 bits, only 64 bits provided
- Laravel's whereBetween method not working with two timestamps
- Implementing UUID as primary key in Laravel intermediate table
Related Questions in WEB-SERVICES
- Apache CXF is unable to handle duplicate localnames
- Why do we call all http services 'Web Api/Web Service'?
- Postman Webservice PHP Curl Code POST request giving forbidden error when run in local
- Migrate ASMX web method to WCF which accepts string array
- PKIX failed when using custom SSLcontext with custom keyStore and trustStore
- Problems in Validations via Web Service in a Vue 3 Application
- Maven plugin 100% compatible Java21 to generate stub classes from WSDL file and generate *.wsdl from java classes? A solution
- Kubernetes Ingress Port to Port route
- How to handle a multi thread tests calling a single thread web service in .Net Framework 4.6?
- oracle.dataaccess.dll keep showing up as reference after build of C# web service using Oracle MDAC
- Your thoughts on the suggested architecture for addressing the challenges and maintenance of third-party API implementation
- Issue with BizTalk register WCF-WSHttp adapter while calling web service
- Does PHP SoapClient creates XML to be sent to webservice end point, based on WSDL file, while using CURL the XML should be manually created?
- Invoice API in Authorize.net like Square
- Publish JAXWS Endpoint in the same port than Spring boot
Related Questions in SAGE-LINE-50
- Cannot create a linked server for Sage Line 50 to SQL Server using the 64 bit driver for Sage
- How to setup Linked Server from SQL Server Express 2019 to Sage Line 50
- Sage Line 50 ODBC issues with Python 3
- Pulling data from Sage Line 50 Cloud
- Update posted transaction using SageDataObject220
- Using access vba to pass the login via variables to automate the login to Sage Line 50 ver20
- how to query multiple endpoints with curl on sdata web serivce
- how to query bank activity with sage sdata service
- Sage Line 50 SQL Query throws column not found error or numeric data is returned
- Sage Line 50 ADODB connection with Classic ASP on IIS6 - Authentication Failed
- Import Inventory Item from Excel to Sage 50 using window scheduled task
- Sage 50 ODBC using PHP-SQL state IM002
- Connecting two web application through API using SDK
- I am trying to synchronise a Sage Line 50 Access database with Mysql via ODBC
- Subquery not working with Access linked tables
Related Questions in SDATA
- Sage 50 SData XML to JSON POST Request
- sData REST APIs for sage 100 ERP
- AccountKey in sData
- How to create a new contact in Saleslogix Infor CRM using DotNetSDataClient
- Sage50 SData POST to tradingaccountCustomerfeed
- how to query multiple endpoints with curl on sdata web serivce
- how to query bank activity with sage sdata service
- Sage 300 (accpac) SDATA Create Customer
- JQuery Headers for internal AJAX call
- Sage 50 2014 SData issues
- Sage Evolution website integration
- DataTable with JS Source
- SData Integration with Sage Accounts 50, 2010 release
- Sage sdata web service issue
- SData - SalesLogix
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 # Hahtags
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.