# WebDev - Ignition Resource (Read all Named Queries with raw SQL, Run Queries, Get Tags, Read Tags, and more)

**URL:** <https://forum.inductiveautomation.com/t/webdev-ignition-resource-read-all-named-queries-with-raw-sql-run-queries-get-tags-read-tags-and-more/87483>\
**Category:** Ignition Exchange\
**Tags:** perspective, vision, ignition81, scripting, database\
**Created:** [March 18, 2024, 1:05pm UTC](https://forum.inductiveautomation.com/t/webdev-ignition-resource-read-all-named-queries-with-raw-sql-run-queries-get-tags-read-tags-and-more/87483 "2024-03-18T13:05:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Noah\_Casey](https://avatars.discourse-cdn.com/v4/letter/n/e480ec/32.png) [@Noah\_Casey](https://forum.inductiveautomation.com/u/Noah_Casey)\
**Post date:** [March 18, 2024, 1:05pm UTC](https://forum.inductiveautomation.com/t/webdev-ignition-resource-read-all-named-queries-with-raw-sql-run-queries-get-tags-read-tags-and-more/87483/1 "2024-03-18T13:05:19Z")

</div>

Hey everyone,

I wanted to share my first submission to the Ignition exchange.  
Exchange Link:

> **[Ignition Exchange](https://inductiveautomation.com/exchange/2622/overview)**
>
> Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.

The resource is free to the public and contains many comments for easily modifying the resource.

The resource contains the following features:

- Read all named queries within an Ignition Gateway
  - The script will grab all projects, named queries, parameters, and raw SQL statements.

- Run named queries with optional parameters.
  - Allows users to enter the query that they want to run with parameters and will return the value as a dataset or will return scalar queries with only the value.

- Get all tag paths within the Ignition Gateway.
  - Allows users to read a full list of providers, folders, and tag paths inside the gateway.

- Get tag path group data.
  - Allows users to search even further with specified search parameters when looking for tag paths.

- Get Simple Health
  - Users can use this as a simple heartbeat to the Ignition Gateway.

- Get System Health
  - Returns Ignition Gateway health such as CPU, RAM, Memory utilization.

- Get Tag Values
  - Users can enter tag paths to return values of every tag path entered.

- Get Tag Value Units
  - Users can enter tag paths and return values along with Engineering units, High, and Low level alarms.

Example return for gathering named queries:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/b/3b89aeeaf680535ef9c551e80e296ccb46eb3b56.png)

API Docs:  
[https://sandalwood.com/systems-integration/ignition-rest-api/#/](https://sandalwood.com/systems-integration/ignition-rest-api/#/)

I hope users find this useful!