Replacing Query Tags with REST API

Ignition
1

In my project, I have about 300 UDTs that contain query tags.

The table they currently reference will be removed soon and replaced by an API.

Since I have only used REST calls for single, standalone tasks and never on this scale, I was wondering what the best approach would be to populate this data using REST calls.

Thanks.

2

Do you still have access to some type of database for making tables?

3

Yes, I have a MSSQL DB for my tables that I can manage.

4

Consider using runScript() expressions instead of query bindings, and have your script cache all of the results in a top-level dictionary. Only call out to the API for missing values.