XOData®

Download platform_app

Business Analytics with OData APIs & OData API Visualizer/Explorer【Please upgrade to latest version 2.0.9】
-------------------------------------------------------
Please check Google's announcement regarding Chrome Apps.
https://blog.chromium.org/2016/08/from-chrome-apps-to-web.html
TL;DR : Starting early 2018, Chrome Apps will no longer be available except on Chrome OS (Chromebooks).
-------------------------------------------------------
Please check https://twitter.com/pragmatiqa for status updates
-------------------------------------------------------
Latest update : 17-May-2017 : XOData 2.0.9 :
To avoid Chrome-58 issue with identity API (crbug-722323)
"Authorization page could not be loaded".
Please see further details in 【Update History】section below.
-------------------------------------------------------
【Summary】
Product Page : http://pragmatiqa.com/product_xodata.html
--------------------------------------------------------
XOData® is a light-weight, practical, easily accessible and generic OData API visualizer/data explorer – that is useful to developers as well as business users, business-process-experts, Architects etc.

- Business Analysts or End-Users can utilize OData Query Builder and Data Visualization for Ad-hoc Self-Service Reporting.
- It assists in rapid prototype, verification, testing and documentation of OData APIs including OData services provided by SAP NW Gateway, Microsoft Azure Marketplace, Office-365, SuccessFactors, SAP HANA etc.

It provides following options to explore OData metadata/services.
- Direct Service/URL access option for visualization and exploration of Publicly accessible OData services or Services that are accessible with Basic Authentication (User/password)
- File upload option for offline visualization of OData metadata (Entity Relationship).

With this Chrome App, it's also possible to explore OData Services that are accessible at localhost or within Intranet.
------------------------------------------------------
【Important】- Please Read
XOData is a subscription App ( charged per month by Chrome Web Store ) and if you want to cancel your subscription, please follow the Chrome Web Help Link https://support.google.com/chrome_webstore/answer/1060830
-------------------------------------------------------
Please note that trial is mainly to check if your API is accessible from Chrome App (e.g. through Basic Authentication). Primary features of XOData can also be checked with reference or publicly accessible OData services in OData Directory ( http://pragmatiqa.com/odatadir/ ) through online XOData http://pragmatiqa.com/xodata
------------------------------------------------------
【OData Directory】
Powered by XOData - is also available online at http://pragmatiqa.com/odatadir/
If you want to check the XOData features with openly accessible OData APIs, there are more than 170 OData APIs in the directory - including 30+ OData V4 and from different service providers.
------------------------------------------------------
【Free Trial】
- Chrome App General Free Trial available on the day of first sign-in.
------------------------------------------------------
【Data Privacy】
tl;dr :
- Your Chrome login-id (email-id) is visible to this Chrome App.
- API data-communication is directly between Chrome (your m/c) & OData API Provider System hence XOData server has no visibility of API data-communication.
- Only if you choose to use "Save as Favourites" feature then metadata url and generated OData Query URL is saved in pragmatiqa database however no data (delivered by API) is visible/stored to PragmatiQa Backend.
- For complete privacy policy, please check website ( http://pragmatiqa.com )
- If and When API document is downloaded from "API Details Tab", Stats of metadata (e.g. count of entities, functions and actions in metadata document) and metadata url is stored in PragmatiQa backend and a download number is assigned to the document for future reference/issue resolution.
- JavaScript Exception messages are logged to PragmatiQa backend.
------------------------------------------------------
【Update History】
09-Apr-2017 : XOData 2.0.8 :
Normalize lowercase OData-Version: 4.0 HTTP response header - If OData API server responds with lowercase "OData Version" header i.e. as "odata-version" then OData version determination was not working.
01-Apr-2017 : XOData 2.0.7 :
Improvements regarding memory, error handling etc.:
e.g. correction for Detached DOM nodes during XOData Doc generation, edge-case issue with Order-by Buttons on Query Builder, exception handling for invalid metadata file uploads etc.
07-Feb-2017 : XOData 2.0.6 :
Correction for single schema metadata + no complex type + non-scaler property type scenario exception.
07-Feb-2017 : XOData 2.0.5 :
API Diagram/details :
Useful features added for exploring APIs with huge metadata/model.
Also helps with screenshots/print of a subset of resources etc.
..2nd level filtering for entities
..Xoom (XOData Zoom + Info : 4 levels ) & Rotate Model display
..XOData Document: Annotations added & Meta-Stats improved
OData Query Builder:
..Improvement in Entity List display for derived but directly accessible entities
..Value-help improved (for fields with null values)

JS Exception Logging implemented:
..JavaScript exception log will be sent to PragmatiQa backend for correction and support.
-------------------------------------------------------
09-Sep-2016: XOData 2.0.4 :
Correction for the issue observed in Chrome 53 -
Issue with Form generation/JSON Representation in generated Document and Create ( CRUD related ) on Query Builder.
-------------------------------------------------------
25-Jul-2016 : XOData 2.0.2 is deployed.
Significant Feature update :
API Details tab is now upgraded to XOData Doc initial version:
- OData API Document is generated by interpreting the metadata document. Generated details include resource representation structure in JSON, top level resource URIs along with property and navigational details etc.
- Rich-text descriptions can be super-imposed on generated document to complete the API documentation. XOData API Log can be used to fill/add request/response details for Methods & Examples section.
- Document can be downloaded as single page nearly static HTML document(responsive). See generated sample without any manual edits : http://pragmatiqa.com/xodoc/sample/trip.html
- In-built editor can be used for APIs upto 50 entities/functions/actions in total (technical consideration due to size of metadata).
- Auto-save is provided for edits using local storage(limited memory). Please download the document after any manual additions.
- Manual edits are saved in local storage (your own m/c) hence there is no privacy issue.
- When API document is downloaded, Stats of metadata (e.g. count of entities, functions and actions in metadata document) and metadata url is stored in PragmatiQa backend and a download number is assigned to the document for future reference/issue resolution.

Apart from API details tab, there are a few other improvements on "Create" Entity feature on Query Builder tab.e.g. For indirectly accessible entities, deep entity/resource JSON representation can be obtained, Though direct creation of resource may not be possible, it can be used for deep insert along with parent entity or for documentation purpose. Also, query builder will now show a hint OData URL for deep resources( indirectly accessible entities ).

There are a few other minor improvements.

Just to clarify :
- For security reasons, remember Details checkbox on Connection tab *does not* remember Password or details added under "Specify Additional Headers for API Requests" section.
- For APIs with huge metadata, there might be a noticeable degradation in performance due to enhanced API document generation. This will be addressed in future through role based access and further processing optimization.

-------------------------------------------------------
03-Apr-2016 : XOData 2.0 is deployed.
Code-refactoring : Namespace, config options etc. to enable :
- Deployment time configurability of UI & Feature Selection
- Runtime configurability ( Based on user-roles )
- Minor bug-fixes
------------------------------------------------------
28-Feb-2016 : Error Message Correction : Added message to user : ensure running the latest version of XOData.
------------------------------------------------------
09-Feb-2016 : Sample Favourites are removed from display in the OData Service list to improve the visibility of own favourites. Samples are available in online XOData at http://pragmatiqa.com/xodata
------------------------------------------------------
07-Feb-2016 : Additional (unrestricted by Browser) HTTP request headers for OData API can be specified on "Connection Tab".
-------------------------------------------------------
Updated on 05-Feb-2016 : If metadata url has parameters(e.g. /$metadata?api_key=xxx ), it will get appended to prepared OData Query URL through Query Builder.
-------------------------------------------------------
Updated on 31-Jan-2016 : context menu enabled for Print.
------------------------------------------------------
Updated on 25-Jan-2016 : Recently used OData Metadata URLs will be available for selection as you typeahead. Metadata URLs for this feature are stored locally hence no privacy issue. [info added : 29-Jan-2016] Please note that the URL history is syncable for your user between your own devices as it uses local storage through Google Chrome API.
------------------------------------------------------
Updated on 11-Jan-2016 : Customized Name Display for Enterprise.
------------------------------------------------------
Updated on 31-Oct-2015 : Font changed to Roboto and other minor changes.
------------------------------------------------------
Updated on 07-Oct-2015 : Color and Transition changes to Dropdown-Menus.
------------------------------------------------------
Updated on 27-Sep-2015 : OData V4 Releated : empty Collection handling in result layout. However, as per V2/V3 and for V4 also, XOData needs null fields to be specified in results for proper table layout.
------------------------------------------------------
Updated on 26-Sep-2015 : OData V4/JSON Function call regression issue due to changes for derivation of links in case of key based results. Reverted.
------------------------------------------------------
【Major Update on 09-Sep-2015】
------------------------------------------------------
- a quick overview of new features on youtube:
https://www.youtube.com/watch?v=_T6a53zqGXQ

- As part of CRUD support in XOData, "Create Single Entity" using auto-generated Form is delivered - Please note that "Create" single entity record feature is still in Beta and must be used only for functional verification of OData APIs from non-production (Dev/Test/Demo) systems. As of now, directly accessible (not contained) single entity record can be created - also supports heirarchial complex types & collections. If required, verify the final OData request/response through in-built XOData API-Log.
- OData API HTTP Request/Response log feature that can be toggled on/off as required.
- Some other general UI improvements around value-helps etc.
------------------------------------------------------
Updated on 12-Jul-2015 : support for hierarchical complex type in Query Builder. e.g. inherited from BaseType or nested complex type. (self-referencing complex type not supported )
------------------------------------------------------
Updated on 26-Jun-2015 :
New features/improvements in Query Builder / Data Explorer:
..value-help / typeahead for where condition fields - quickly prepare a query for testing etc.
..Result display when nested tables in data-table: header alignment corrected - also compressed display of nested table where possible.
..Function calls will add condition fields for float ( single, double, decimal ).
------------------------------------------------------
Updated on 26-May-2015 : Turtles Update is now deployed to XOData Chrome App.
New Features include significant improvements to OData Query Builder : e.g. Support for Deep filtering, Deep Expand (except V4), filtering support for V4 Complex Type Collections.
------------------------------------------------------
Updated on 29-Apr-2015 : Bug-Fixes : OData Query Builder
- OData URL : Add : Long integer +L, double +m, decimal +d, single +f. datetimeoffset for non-V4 handled but appropriate date format should be selected by user from advance settings.
- Regression from favourites feature: URI encoding was being applied.
- DataTable resize issue.
- Message display area is fixed
------------------------------------------------------
Updated on 30-Mar-2015 : Save as Favourites :
Save prepared OData Queries on Query Builder as Favourites. Use it as Test Cases or Reports for one click access later.

Only the prepared URL and layout info is kept in backend for the favourites.
API Data communication is directly between browser and API as before - so no data is stored on PragmatiQa Backend apart from prepared URL config that is saved as Favourites against your email-id.
------------------------------------------------------
Updated on 25-Feb-2015 : Experimental Support for NTLM authentication
------------------------------------------------------
Updated on 19-Feb-2015 : Pivot table selection along side any other chart was expected - now charts can be generated without Pivot table too.
------------------------------------------------------
Updated on 01-Feb-2015 : Improved axis ordering for Charts
and Scrollbar & other usability related changes for data-tables
------------------------------------------------------
Updated on 21-Jan-2015 : Timeout limit is increased as slow APIs are unable to return the results for [All Data- with batches of 5000 records].
------------------------------------------------------
Updated on 4-Jan-2015 : MaxDataServiceVersion will not be sent in request header to avoid issue with OData V4.0 services provided by .NET Web API 2.2
------------------------------------------------------
Updated on 12-Dec-2014 : Added auto-Ranking Calculations (Top-10 & V. High - Low ) & auto-reduction for Data-Visualizations.
------------------------------------------------------
Some of the new features include:
- User Friendly and Interactive Data Visualization ( Data Charts, Pivot Table and World Map )
- Interactive Query Builder: Support for complex queries including OData V4 ( All formats supported, including ATOM & JSON )
- Easy Data Acquisition: Complete data for the prepared query will be retrieved using Server or Client side paging.
- Simplified results display in Data Mode: Complex hierarchical data (1:1 or N:1 relations) is flatten in table display to be used for data visualization.
See some examples here and feel free to try by yourself : Tweet-Stream of XOData ( https://twitter.com/search?src=typd&q=xodata )
-Subscribed Azure Datasets will be available in Service List dropdown after login using Primary Account Key.
--------------------------------------------------------
Further Details:
XOData Chrome-App features include:
- Access to local/Intranet/Internet based OData Services with Basic Authentication.
- Can handle huge metadata documents with hundreds of entities - including metadata documents having more than two schema elements.
- Visualization support for Complex Types in metadata.
- Query Builder/Data Explorer has several improvements including Key based query preparation, ability to edit the prepared URL, options to set the data-format and date format, complex inline-data handling in result layout, effective support for expand etc.
- Support for OData V4
- Better Error/Message Handling
------------------------------------------------------
【Support】
Please report any issue to [ [email protected] ].