# Getting Data from URL **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [June 17, 2024, 2:58pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957 "2024-06-17T14:58:13Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Anant\_Upadhyayula](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Anant\_Upadhyayula](https://forum.inductiveautomation.com/u/Anant_Upadhyayula)\ **Post date:** [June 17, 2024, 2:58pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/1 "2024-06-17T14:58:13Z")
I have a URL that returns that data in a format show below. Is it possible to reconstruct the data back into a table that can be filtered with a criteria. ![Test (2)](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/b/9b25cc095803db49c14167cd4fa65982f5fa70c1.png) ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [June 17, 2024, 3:00pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/2 "2024-06-17T15:00:52Z")
I think you can use an HTTP binding on a tables data prop, and it should work as is. > **[HTTP Bindings in Perspective | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/perspective/working-with-perspective-components/bindings-in-perspective/http-bindings-in-perspective)** > > The HTTP Binding type allows you to use HTTP get/post protocols to interface with other API's. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 17, 2024, 3:06pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/3 "2024-06-17T15:06:32Z")
> [@Anant\_Upadhyayula](#): > > ... that can be filtered with a criteria. After your HTTP binding, add a Script Transform to your binding and apply the filtering there. Tip: If you want the table to update if the filter criteria changes then some further rearrangement is required. Explain your setup and a nicely cropped screenshot of your user interface if it will help us. ---
**Author:** ![Anant\_Upadhyayula](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Anant\_Upadhyayula](https://forum.inductiveautomation.com/u/Anant_Upadhyayula)\ **Post date:** [June 17, 2024, 3:33pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/4 "2024-06-17T15:33:19Z")
![Test4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/a/4ac3a6a5dc5998aeead652a9e5e2ab61b979bee4.png) I had a static URL. I used the HTTP binding and it returned the data in the attached format. I bound the URL to a table, it loaded all 15,600 rows. Applying a filter would be nice but I do not know much about it. Thank you for your help. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 17, 2024, 3:40pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/5 "2024-06-17T15:40:19Z")
1. On the table properties set `props.filter.enabled : true` and see if that's good enough for you. You can pre-populate the filter by setting a value: `props.filter.text : M8` The user could then clear that. 2. Alternatively, enable the filters on whichever columns are relevant. `props.columns.0.filter.enabled : true` `props.columns.0.filter.visible : always` If you want something better then write a quick specification. ---
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [June 17, 2024, 3:40pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/6 "2024-06-17T15:40:25Z")
Hi, Get a read at [Perspective - Table | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/components/perspective-components/perspective-display-palette/perspective-table#filter-properties) ---
**Author:** ![Anant\_Upadhyayula](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@Anant\_Upadhyayula](https://forum.inductiveautomation.com/u/Anant_Upadhyayula)\ **Post date:** [June 17, 2024, 5:42pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/7 "2024-06-17T17:42:15Z")
I tried the method described, that gave me a new issue. The data coming from the HTML source is in the form of a text so hard to figure out if there are spaces etc in it. It is not recognizing the filter value on the props.filter.text. however when I test view it gives a filter choice and It recognizes there. ![Test5](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/00a1d1530f2b81f7c807eecdc6d53aba8162c48a.png) Is there a way to convert the entire data in the column to integer so a number search would give the result I need ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 17, 2024, 5:49pm UTC](https://forum.inductiveautomation.com/t/getting-data-from-url/91957/8 "2024-06-17T17:49:20Z")
Try, `props.columns.1.render : number` rather than auto. Then put your filter value into `props.columns.1.filter.number.value` You might also want to set `props.columns.1.filter.number.condition : equals`