How to import python library requests

[mch8418]

how can I use python traditional library requests?

[campopianoa]

Hi there,

You can add a server module and import requests as you would normally. For example,

[mch8418]

Nice! I try it out already. Do you know how to upload my excel file or .cvs file?

[campopianoa]

Are you asking about uploading your CSV data into an Anvil app?

If so, there are many examples on the forum for uploading data into Anvil. For example,

Importing existing data into Data Table

@adhamfaisal Hi there. Here’s a little app that downloads some sample data onto your computer, and then allows you to upload it into a data table. I hope this helps to clarify things. [com-video-to-gif] clone: https://anvil.works/build#clone:TIBQ7CSOSPIXHJ4R=UGRKSUZCMLOVGKR7NAAF3TDN

[mch8418]

That is not really what I want. I want to upload .csv file as database, then I can use the data when a form was show up.

by the way, how can I insert data pieces that I extract from web site into a table cell or data grid cell?

[campopianoa]

A couple of things.

I may be misunderstanding the question, but uploading a CSV into the Anvil DataTable service (which acts as database) will accomplish what you are describing. That is, it will allow you to pull values from the database into your forms.

Note that you may also consider using the Uplink service from Anvil which will allow you to send data from your local computer up to the Anvil DataTable (database). Described here:

Importing existing data into Data Table

@adhamfaisal I would suggest learning uplink as you will be able to use modules that are not available in the python 2 runtime. The uplink tutorial is a good one. In the IDE, click the icon and then “uplink” and follow the instructions. Perhaps try to modify the app I sent previously (change the runtime to python 2 and remove/ignore the “click to upload” button). Then, on your computer make a script with the following details: import anvil.server from tables import app_tables import p…

It would be helpful if you could show us what you have tried, or even a similar example that might make it clearer what you are looking to accomplish. Have you tried looking at the DataTables service documentation?

Lastly, if possible please try to post new questions as a new topic. This makes topics easier to find on the forum. Please read some helpful suggestions below.

How to ask a good question

Welcome to the Q&A Forum! Help each other by asking questions about Anvil, and answering other people’s. Post each question as a new topic - and if someone helps you, don’t forget to say thank-you. Try to provide information to help people answer your questions: Be specific about what you’re trying to do. Be specific about what your problem is (eg what’s not working), and what you have already tried. Include code samples if you can. It often helps if you can share your app’s source code and …

[mch8418]

I had try out the data tables services, very nice! Now I am trying to figure out the uplink service. I will post my new question in new thread, thank you! Nice job!