POST Request

[John Currey]

I'm struggling to figure out how to put data in a database with a POST request. In the example provided, I understand populating the header and data as a JSON dictionary. 

With the data from the example below, can someone show me what the URL should be to update a database? I assume it's something like the following, but I have not been able to get it to work. I think I just need to be pointed in the right direction. Thanks. 

• p = requests.post('https://s3.sportsdatabase.com/Yotta.MLB/query.json?sdql=something',headers = headers)

header: { "token": "YOUR_TOKEN", "user": "YOUR_USERNAME", "action": "replace" } 

data: { "date": 20200310, "t:team": "Bulls","o:team": "Cavaliers", "t:site": "home","o:site": "away", "t:points": 108,"o:points": 103 }

[Joe Meyer]

John,

here is a python snippet for uploaded an NBA game:

   import requests

   url = "https://s3.sportsdatabase.com/api" 
    d = { "date": 20200310, "t:team": "Bulls","o:team": "Cavaliers", "t:site": "home","o:site": "away", "t:points": 108,"o:points": 103 }
    h = {'token':JC_TOKEN,'client':'jcurrey','league':'NBA','action':'update'}
    ret = requests.post(url,json=d, headers=h)
    print("ret:",ret.status_code,ret.text,)

when you are ready to build your database, you use:

    h = {'token':JC_TOKEN,'client':'jcurrey','league':'NBA','action':'build'}
    ret = requests.post(url, headers=h)
    print("ret:",ret.status_code,ret.text,)

and you will see your NBA database at:

https://s3.sportsdatabase.com/jcurrey.NBA/query.html

best regards,

Joe Meyer

http://SDQL.com

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/b0363c65-70bf-4ec5-9424-f39c18a5640en%40googlegroups.com.

[John Currey]

Thanks, that is super helpful!

[John Currey]

OK, I'm starting to get how this works. I've updated data in https://s3.sportsdatabase.com/jcurrey.NBA/query.html.

I tried to create an MLB database with the following code and output:

The output suggests it worked, yet I can't access https://s3.sportsdatabase.com/jcurrey.MLB/query.html

[Brian Goodness]

I was just trying to load some data, based on documentation on the main website (https://s3.sportsdatabase.com). I couldn't get the data loading to work properly, until I followed the instructions here in this post.

It looks like I was using the "user" key in the structure of my POST request, when it should have been using the "client" key, as referenced here. Could the documentation on the main site be updated to reflect this change? See the highlighted line in the screenshot below.

Thanks! --Brian