Data Resource - Data Selector

Undraw Environment

About

A data selector is a data uri expression that permits to select:

If you are new to the concept of data selector, we encourage you to take a look at this page: Learning Tabulify - Step 4 - How to select Data Resources

Syntax

This syntax select data resources listed in the connection

globPath[@connection]

where:

You can reference each wildcard character in a target data uri to define the target resources.

File System

For a file system, the following special character are supported in the path:

  • / for the separator
  • . to design the current working directory
  • .. to design the parent directory of the current working directory

Example:

  • Absolute
# Linux
/globPatternForDirectory/globPatternForFile@fileSystemConnection
# Windows
C:\globPatternForDirectory\globPatternForFile@fileSystemConnection
  • Relative
# Linux (and Windows)
../globPatternForDirectory/globPatternForFile@fileSystemConnection
# Windows form works also but is not recommended
..\globPatternForDirectory\globPatternForFile@fileSystemConnection

Sql Database

For a sql database, the following characters are supported in the path:

  • ., for the path name separator
  • / to design the current schema
  • // to design the parent (schema, catalog)
# an sql object pattern
[catalogueGlobPattern][.schemaNamePattern.]objectNamePattern@database
# a sql schema pattern
//.schemaNamePattern
# a sql catalog pattern
//.//.schemaNamePattern

Web

For a web system, Tabulify supports passing directly an URI/URL as a data selector.

Only in bash based terminal, see why

tabli data info "https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description"
Information about the data resource (https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description@https:--en.wikipedia.org-w)
attribute         value
---------------   -----------------------------------------------------------------------------------------------------------------
AbsolutePath      https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description
Characterset      ISO-8859-1
Connection        https:--en.wikipedia.org-w
Count             1
DataUri           https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description@https:--en.wikipedia.org-w
LogicalName       api
Md5               b61936451e935f25c7683ede9b26801b
Name              api.php
Parent            w
Path              https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description
Sha384            a27590cd933c93a9fd7dda31e0d20d5fab3ee0b952f6382c4d615d732df64347523e5368d007c6d4076a3d494b050acf
Sha384Integrity   sha384-onWQzZM8k6n9fdox4NINX6s+4LlS9jgsTWFdcy32Q0dSPlNo0AfG1AdqPUlLBQrP
Size              -1
Type              application/xml




Related HowTo
Undraw Environment
Learning Tabulify - Step 4 - How to select Data Resources

To select a data resources such as a file or a database table, Tabulify uses the concept of: and dependency (Do we select also the dependent data resources) This page goes through this concepts...
Undraw Environment
Learning Tabulify - Step 6 - How to transfer Data Resources

In Tabulify, when you want to manipulate data, it's called a transfer. You want to move data, you transfer You want to copy data, you transfer You want to insert data, you transfer You want to...
Undraw Environment
Learning Tabulify - Step 7 - How to execute a Query

For Tabulify, a query is a script that when executed returns a content resource. In the case of a Sql Query (ie a SELECT statement), the result is a data set in tabular format. The selector of a query...

Task Runner