Hello Sharmila,
Thank you for reaching out. You could use Placement Performance Report to retrieve the data aggregated at placements level via AdWords API. The FinalUrls field will give you the list of final URLs that were added against the Ids of the placements. You might find this code sample useful to download the report data via API. Also, the "Where Ads showed" data in the UI can be pulled using the Automatic Placements Report. Please check the guide on how the API reports are mapped to the Google Ads UI. Let us know if you need any additional information.
Regards,
Nikisha Patel, Google Ads API Team