Data Import Examples

Loading data from CSV, JSON, and XML files.

DocumentationAPI Reference

All Examples

Complexity

Search

No examples match your filters.

Data Import Patterns

CSV Import

<q:data name="products" source="/data/products.csv" format="csv">
  <q:columns>
    <q:column name="id" type="number" />
    <q:column name="name" type="string" />
    <q:column name="price" type="number" />
  </q:columns>
</q:data>

<q:loop items="{products}" var="product">
  <p>{product.name}: ${product.price}</p>
</q:loop>

JSON Import

<q:data name="config" source="/data/config.json" format="json" />

<p>App Name: {config.appName}</p>
<p>Version: {config.version}</p>

XML Import

<q:data name="catalog" source="/data/catalog.xml" format="xml">
  <q:xpath select="//product" />
</q:data>

<q:loop items="{catalog}" var="item">
  <div class="product">
    <h3>{item.title}</h3>
    <p>{item.description}</p>
  </div>
</q:loop>

Data Transformations

Filter

<q:data name="products" source="/data/products.csv" format="csv">
  <q:transform type="filter" condition="{price > 100}" />
</q:data>

Sort

<q:data name="products" source="/data/products.csv" format="csv">
  <q:transform type="sort" field="price" order="desc" />
</q:data>

Limit

<q:data name="topProducts" source="/data/products.csv" format="csv">
  <q:transform type="sort" field="sales" order="desc" />
  <q:transform type="limit" count="10" />
</q:data>

Compute

<q:data name="products" source="/data/products.csv" format="csv">
  <q:transform type="compute" field="total" expression="{price * quantity}" />
</q:data>

Remote Data

<q:data name="users"
        source="https://api.example.com/users"
        format="json"
        cache="300" />

Related Categories

• State Management - Store imported data
• Loops - Iterate over data
• Database Queries - Import to database