Hello Chirag,
You may use the below query to pull these details:
SELECT
ad_group_ad_asset_view.performance_label,
asset.id,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.path1,
ad_group_ad.ad.responsive_search_ad.path2
FROM
ad_group_ad_asset_view
LIMIT
100
Please give this a try and let us know if you have any issues. The assetApprovalStatus data is not yet available through the API. Please keep an eye on our
blog for more details.