wire.data.DataSource

Use the DataSource class to create a connection to a data service.
Properties
Name
Type
Default
Description
Ajax
object
null
Ajax options used by the data source service provider to make calls to the data service if using jQuery Ajax.
Headers
object
null
Attached headers to the data service call.  See Authentication for an example.
Model
object
null
Optional wire.data.DataModel to be used by the data source.
Provider
object
null
Configuration for the service provider used by the data source.  This will be specific to the service provider.  Visit Service Providers for details.
ServiceRoot
string
null
URL end point for the data service used by the data source.  
Methods
Name
Description
allow
Returned from the service provider.  See Allow details below.
cast
Static method that casts an object with the same data source properties into an instance of the DataSource class.
delete
Deletes data from a data service.  See Writing Data Deletes for details.
deleteAsync
Deletes data from a data service.  See Writing Data Deletes for details.
exec
Executes a query in a data service.
execAsync
Executes a query in a data service.
getResponseTable
Call into the service provider to transform data returned from a data service into a DataTable.
serviceProvider
Returns the service provider instance.  Visit Service Providers for details.
test
Service provider must set allow().test for consumers to be sure testing the data service is supported.
write
Use this method to update data in a data service.  See Writing Data Updates for details.
writeAsync
Use this method to update data in a data service.  See Writing Data Updates for details.
Authentication
Use the Headers property to attach headers to the data service call.
1
const token = "Ajb9fur9jgk9f6jr";
2
​
3
const source = new wire.data.DataSource("custom", {
4
    Headers: { Authorization: "Bearer " + token }
5
});
Copied!
The example above uses a token with the Bearer authentication.  Below is an example that uses Basic authentication with a user name and password.
1
const userName = "pdougherty";
2
const password = "Password21#quot;
3
​
4
const source = new wire.data.DataSource("custom", {
5
    Headers: { Authorization: "Basic " + window.btoa(user + ":" + password) }
6
});
Copied!
Allow
The allow method exposes certain aspects of functionality available in the service provider.
Name
Type
Default
Description
discover
boolean
false
Does the service provider allow meta data about data elements in the data service to be dynamically read.
tableQuery
boolean
true
Does the service provider support building queries using TableQuery.
tableQuery.orderBy
number
0
Does table query support include the orderBy function.  0 = does not support order by, 1 = order by on a single field is supported, 2 = order by supported on multiple fields.
tableQuery.groupBy
boolean
false
Does the service provider support the groupBy function.
test
boolean
false
Does the service provider support testing data service availability.
storedProcedure
boolean
false
Does the service provider support building queries using 
Discover Methods
Use the following methods to read meta data about the data contained in a data service.
All the discover methods take a singe options parameter.  This parameter will be specific to the service provider if applicable at all.  See DataSource Discovery for examples.  Visit the service provider documentation for details on discovery options.
Name
Description
discoverCatalogs
Returns the list of catalogs or databases from a data service using a synchronous call.
discoverCatalogsAsync
Returns the list of catalogs or databases from a data service using an asynchronous call.
discoverEntities
Returns the list of entities or tables from the database defined in the data service connection using a synchronous call.
discoverEntitiesAsync
Returns the list of entities or tables from the database defined in the data service connection using an asynchronous call.
discoverFields(config)
Returns the list of fields for an entity or table specified in config.entityusing a synchronous call.
discoverFieldsAsync(config)
Returns the list of fields for an entity or table specified in config.entityusing an asynchronous call.
discoverProcedures
Returns the list of stored procedures from the database defined in the data service connection using a synchronous call.
discoverProceduresAsync
Returns the list of stored procedures from the database defined in the data service connection using an asynchronous call.
discoverProcedureParameters
Returns the list of parameters for a stored procedure specified in config.procedureusing a synchronous call.
discoverProcedureParametersAsync(config)
Returns the list of parameters for a stored procedure specified in config.procedureusing an asynchronous call.
​
​
For more on data sources, visit Connecting to Data.

wire.data.DataSet

wire.data.DataTable

Last modified 1mo ago

Copy link

Contents