Use the below script, you can simply read the IDs from the excel file and call the URL in a loop, the program will download all the picture by giving PictureIDs into your local computer.

SELECT 'PICTURE_ID','OBJECT_ID' FROM 'SAP_SPORTS_FND'.'.schema::PICTURES' where 'OBJECT_TYPE' = 'PERSON' AND 'OBJECT_CLASS' = 'Face'.ģ.Develop Python script to read IDs from local file and download pictures from the system. This table stores picture information along with the reference object.Įxecute below SQL script, we will get all the PlayerID and relevant PictureID. Let’s go to WebIDE->Catalog,find table “.schema::PICTURES”. In the first step, we know how to get the final picture URL, now we need to know the relationship between Player and Picture. When you open this URL in your browser, if all goes well, you should see the picture.Ģ.Find the mapping between Player and Picture. Https:/sap/sports/fnd/db/services/public/xs/pictures.xsjs?PICTURE_ID= Now you can replace the domain and PICTURE_ID as you want, the final URL would be like below: Inspect player main page, you could find URL like below: You have the authorization to access SAP Sports One backend system.

Your Python environment is setup and running well.

Let’s start with solution 3 step by step. No additional dev effort for solution 1 and solution 2 since they are just manual work.

Develop a simple Python script, bulk download all the pictures.

Navigate to each player’s main page, find the pic URL and open the URL in a new Chrome tab and save the picture to your local computer.

Navigate to each player’s main page, make a screenshot and save to your local computer.

I want to download all the player pictures from the system and save to my local computer. Unfortunately, since the download feature is not currently available, you cannot download pictures directly from the system. In SAP Sports One, a player picture can come from a third data provider, or they can be manually maintained by club staff.

Download sporus