# How do I pull data from a text file on a website?

**URL:** <https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706>\
**Category:** Getting Started\
**Created:** [August 3, 2026, 8:59pm UTC](https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706 "2026-08-03T20:59:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Chance](https://forum.xojo.com/user_avatar/forum.xojo.com/paul_chance/32/22072_2.png) [@Paul\_Chance](https://forum.xojo.com/u/Paul_Chance)\
**Post date:** [August 3, 2026, 8:59pm UTC](https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706/1 "2026-08-03T20:59:14Z")

</div>

I need to go to a site/URL that requires a username and password (which I have) and presents me with a (URLs) list of .txt files so that when I click on one, [https://www.xyz/2026/Thisfile.txt](https://www.xyz/2026/Thisfile.txt), opens to a text file I can copy to the clipboard and paste into whatever my next step is.

In another language, I used a command that took the username and password and full URL to the .txt file, resulting in it being opened in a browser window. I’m guessing Xojo has a similar command.

I’d like to copy that text data into a variable or clipboard for parsing and skip the copy/paste step.

Once there, how to I programmatically pull the .txt content into my program (variable or Clipboard) so I can parse it for database (SQLITE) storage and perhaps later export it as a JSON file.

In short, I’ve seen commands to get there, but don’t know how to extract it.

---

<div class="post-metadata">

**Author:** ![brian\_franco](https://forum.xojo.com/user_avatar/forum.xojo.com/brian_franco/32/156_2.png) [@brian\_franco](https://forum.xojo.com/u/brian_franco)\
**Post date:** [August 3, 2026, 9:08pm UTC](https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706/2 "2026-08-03T21:08:34Z")

</div>

Hi @Paul_Chance

Worth a watch: [https://www.youtube.com/watch?v=T\_01qendWaY&t=2438s](https://www.youtube.com/watch?v=T_01qendWaY&t=2438s)

and read up on URLConnection: [https://documentation.xojo.com/api/networking/urlconnection.html](https://documentation.xojo.com/api/networking/urlconnection.html)

---

<div class="post-metadata">

**Author:** ![MarkusR](https://forum.xojo.com/user_avatar/forum.xojo.com/markusr/32/685_2.png) [@MarkusR](https://forum.xojo.com/u/MarkusR)\
**Post date:** [August 4, 2026, 10:27am UTC](https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706/3 "2026-08-04T10:27:54Z")

</div>

> [@Paul\_Chance](#):
>
> I need to go to a site/URL that requires a username and password (which I have) and presents me with a (URLs) list of .txt files

you must know how the access works.  
protected by .htaccess , or login form which sends form data and return a access token.  
you could test Basic Auth  
`https://user:password@www.xyz`

if you need the Clipboard in Xojo

> **[Clipboard — Xojo documentation](https://documentation.xojo.com/api/user_interface/clipboard.html#clipboard)**
>
> Class

SQLite

> **[INSERT - SQLiteDatabase — Xojo documentation](https://documentation.xojo.com/api/databases/sqlitedatabase.html#sqlitedatabase)**
>
> Class

---

<div class="post-metadata">

**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\
**Post date:** [August 4, 2026, 3:13pm UTC](https://forum.xojo.com/t/how-do-i-pull-data-from-a-text-file-on-a-website/88706/4 "2026-08-04T15:13:30Z")

</div>

I think (my memory said) I saw that in this forum, but where ?