MLB API Showcase
-
I have a spreadsheet that I've created that uses the API database. I also copy/paste my inventory into it. I started it last year and keep updating it to make it more automated and easy to use. It is not an end-user application, but I use it every time I play The Show.
I have a YouTube channel where I have shown it off (in some rather long, boring videos) if you'd like to see it:
App Name: Lineup & Depth Chart
URL: https://www.youtube.com/channel/UCcG7Q-uLvFbC2KpIAx1oSeg
Platform: Excel
Code: None (Excel formulas)
Functions: Provides lineups of Live teams and teams I create (My Squads). Provides a depth chart (by position and attribute) of my inventory. Keeps track of the players I have leveled up with PXP (and uses the updated attributes in My Squad teams).It's been a couple of months since I've added a video with my updates to the workbook (we've recently gotten a new lab puppy which makes it difficult to stream), but you'll get the idea of what I've done.
-
App Name: ShowStat
URL: http://sideburn.org/mlb22
Platform: Web
Code: public site itself is static for performance but using python to do the calculations, generation, analysis. Normal web tech otherwise: sql, sqlite, html/css, jquery, chart.js.
Functions:Graphs a players attributes progression from the updates. I then overlay with the correlated real life stat of the attribute using a trend formula I've come to via analysis of data.
The Progression give insight into cards that may be catching up to thier reallife stats and it's interesting to see. I use this to predict card updates for investing. I sporadically update the public side of site.
Right now i haven't updated the site with the latest update from 8/19, so you can compare what it's predicting for 8/19 vs the actual update to confirm the predictions.
-
We're late to the party!
App Name: ShowZone
URL: https://showzone.gg
Platform: Web and mobile (Android app already released; iOS in the works)
Code: The backend is mostly in Python with a few microservices in jS/Node. Front-end is React/NextJS.
Functions: It does a little bit of everything. We have tools for Flipping, tracking collection costs, tracking your collection progress, team builder, advanced data (True Overall & Meta Overall), card builder, and SO much more. -
B Blind_Bleeder_PSN referenced this topic on
-
I don't know if this is looked at anymore, and I posted this in the DD section of the forum, but I thought I'd share here since it's relative to this topic.
I created a tab in my Lineup & Depth Chart spreadsheet that enables me to search for players by position and division (NLE, NLC, ALW, etc.).
I'm working on Team Affinity and was tired of searching for positions by team, so I took an hour and created this tab. To be fair, I used my depth chart tab that can search by position and attribute as my template.
-
Any suggestions on how to create a custom iOS app that can authenticate and retrieve listings? Just looking for some sample swift code
-
I was wondering for the game log api if we can get the name of the league included not just league.
-
A buddy and I have created a "companion" website for MLB The Show.
Website: https://www.theshowbase.com/
Android app: https://play.google.com/store/apps/details?id=com.theshowbase
Platform: Web/App
Code: Nextjs/Python
Functions: Database, prices, team builder, mini games (bingo, pack opener, grand slam guess, etc) and much much more.We are proud of the work so far, and keep adding features, tools and similar - You are more than welcome to post any feedback or specific request.
As a side note I think our team builder is the best there is out there
-
I really like the APIs, and have used Excel/Power BI/Power Query to pull in data for analysis. The only one I can't get to work is the "Inventory" one. On the documentation, it states "User must be logged in to make this API call".
https://mlb25.theshow.com/apis/docs/inventory
I can't seem to pass my login information to "My Account". I'm guessing it might be because there are 4 different ways to log in (The Show, Xbox, PS or Switch). I've searched a bunch of places on the web, and it looks like others struggle with the same problem. I know that Showzone has figured it out, but I'd love to simply pull this data myself.
Anyway - let me know if anyone has figured this out. Thank you!
-
@MarioMendoza935_XBL said in MLB API Showcase:
I really like the APIs, and have used Excel/Power BI/Power Query to pull in data for analysis. The only one I can't get to work is the "Inventory" one. On the documentation, it states "User must be logged in to make this API call".
https://mlb25.theshow.com/apis/docs/inventory
I can't seem to pass my login information to "My Account". I'm guessing it might be because there are 4 different ways to log in (The Show, Xbox, PS or Switch). I've searched a bunch of places on the web, and it looks like others struggle with the same problem. I know that Showzone has figured it out, but I'd love to simply pull this data myself.
Anyway - let me know if anyone has figured this out. Thank you!
My son gave me some code to work off of a couple of months ago, but I haven’t taken the time to massage it. I put in a request for them to add parameters for username and password, but it never happened. I need to try the code my son gave me…but, I need an incentive too, and 25 isn’t giving me that…
-
Okay, I have been playing more with google ai studio to create a program using the API data instead of using a manually updated spreadsheet. Here is what I have so far. I may look into expanding it more and maybe implement some more reports if I come up with them.
There were definitely some false starts and bugs along the way.
Here is the main Screen
-
The ability to manually fetch data from the servers and then the ability to export and import that data so I don't need to pull the data every time
-
Imported player count
-
Reports - I currently have two implemented. My flashbacks and legends per team count and a list and count of a specific teams card series
-
Search and filters
-
A details link that displays more info on the card including the art, location and secondary positions.
-
-
@Dolenz_PSN said in MLB API Showcase:
Okay, I have been playing more with google ai studio to create a program using the API data
Is this something you can share? This looks great. Do you have a technical background?
-
@MarioMendoza935_XBL said in MLB API Showcase:
@Dolenz_PSN said in MLB API Showcase:
Okay, I have been playing more with google ai studio to create a program using the API data
Is this something you can share? This looks great. Do you have a technical background?
I have a modicum of technical knowledge but nothing that really helped me with this. What skills did help me with this is 30 years or so of working in IT support. I was able to help the program debug some errors it had because there were times it just was not working.
For example it kept pulling the same page over and over again and swearing that the data contained duplicates and I had to specifically ask it "Are you sure you are properly incrementing the page number and not just pulling page 1 over and over again?"
But I will try and share. I have never done this before so I am not sure how it works. I would highly suggest that you fetch fresh data one time then immediately export and then use the import function. There should be no need to fetch again until SDS has actually added cards, simply import the existing data as it is much faster. The initial fetch takes several minutes. I had to slow it down because the server was throttling the app for pulling too much too fast.
I did this on a PC in a chrome browser. I have no idea if it will work in other environments.
Let me know if it works for you
-
@Dolenz_PSN said in MLB API Showcase:
Let me know if it works for you
It works for me!
I "fetched" the data, which just took a few minutes. The "2686" unique players matches what I have done via Excel/Power Query. When you mention the "duplicates", I had the same issue in Power Query. I was basically loading page 1, 108 times. Once I got it to "loop", everything is fine.
I filtered immediately on "Pirates, Legends & Flashbacks", and it matches what I have in Excel. This is really great stuff.
P.S. I didn't have to do the "Export/Import" function to get this to work. I did do an Export just to see what was in it, and it's the same JSON file that I'm importing into Excel.
-
@MarioMendoza935_XBL said in MLB API Showcase:
@Dolenz_PSN said in MLB API Showcase:
Let me know if it works for you
It works for me!
I "fetched" the data, which just took a few minutes. The "2686" unique players matches what I have done via Excel/Power Query. When you mention the "duplicates", I had the same issue in Power Query. I was basically loading page 1, 108 times. Once I got it to "loop", everything is fine.
I filtered immediately on "Pirates, Legends & Flashbacks", and it matches what I have in Excel. This is really great stuff.
P.S. I didn't have to do the "Export/Import" function to get this to work. I did do an Export just to see what was in it, and it's the same JSON file that I'm importing into Excel.
I use the export and import to speed things up. There is no reason to refetch the data again until SDS releases a new batch of cards.
Maybe later I will try and add the buy now and sell now prices to the details page.
