# Get table data form a website.
**URL:** https://forum.kx.com/t/get-table-data-form-a-website/11551
**Category:** Community Support
**Tags:** kdb-and-q
**Created:** [June 12, 2017, 2:59pm UTC](https://forum.kx.com/t/get-table-data-form-a-website/11551 "2017-06-12T14:59:00Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@VA1](https://forum.kx.com/u/VA1)
#### Post date: [June 12, 2017, 2:59pm UTC](https://forum.kx.com/t/get-table-data-form-a-website/11551/1 "2017-06-12T14:59:00Z")
Hi Gurus,
Is there any way I could come to a website like this: https://www.instituteforsupplymanagement.org/ismreport/mfgrob.cfm?SSO=1 and pull data the “MANUFACTURING AT A GLANCE” table or the whole table from that website? I guess I somehow need to load the webpage through KDB and use SSR function?
Or where can I find info on how to use KDB for pulling data using http requests?
Regards, VA
---
### Author:  [@effbiae](https://forum.kx.com/u/effbiae)
#### Post date: [June 12, 2017, 5:57pm UTC](https://forum.kx.com/t/get-table-data-form-a-website/11551/2 "2017-06-12T17:57:00Z")
the url is https, so you could look up how to setup TLS in q. or…
here’s a start (on linux/mac at least):
q)\c 30 1000
q)system(“(curl https://www.instituteforsupplymanagement.org/ismreport/mfgrob.cfm?SSO=1 \>mf.txt)”)
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 90496 0 90496 0 0 35438 0 --:–:-- 0:00:02 --:–:-- 35433
q)(first where {count ss[x;“MANUFAC”]}each x)\_x:read0`:mf.txt
“\MANUFACTURING AT A GLANCE\
”
“May 2017\”
“\”
“\”
“\\
\
Index\”
“\ | Series\
Index\
May\”
“\ | Series\
Index\
Apr\”
“\ | Percentage\
Point\
Change\”
“\ | \
\
Direction\”
“\ | Rate\
of\
Change\”
“\ | \
Trend\*\
(Months)\”
“\”
“\”
“\\PMI\®\\\”
“\ | 54.9\”
“\ | 54.8\”
“\ | +0.1\”
“\ | Growing\”
“\ | Faster\”
“\ | 9\”
“\”
“\”
“\| \New Orders\\”
“\ | 59.5\”
“\ | 57.5\”
“\ | +2.0\”
“\ | Growing\”
..
| | | |