I'm able to list ads:

https://developers.google.com/google-ads/api/fields/v5/ad_group_ad

select     ad_group_ad.ad.id,     ad_group_ad.ad.name from     ad_group_ad 

And media files:

https://developers.google.com/google-ads/api/fields/v5/media_file

select     media_file.id,     media_file.media_bundle.url from     media_file 

But I'm unable to connect the two. I tried many things:

This gives: The following field may not be used in SELECT clause: 'ad_group_ad.ad.image_ad.media_file'.

select     ad_group_ad.ad.id,     ad_group_ad.ad.image_ad.media_file from     ad_group_ad 

Then this gives: Unrecognized field in the query: 'ad_group_ad.ad.image_ad.media_file.id'.

select     ad_group_ad.ad.id,     ad_group_ad.ad.image_ad.media_file.id from     ad_group_ad 

And tried to remove all the prefixes from ad_group_ad.ad.image_ad.media_file.id without any success. I also tried the ad_group_ad_asset_view, but that returned empty response for all the customers I tried, and it also doesn't have a media file ID.

Is there a solution?

1. When I run an ads-script to call the "spreadsheet" API. I want to enrich a sheet by duplicating some rows according to values I have in a script.

How should I do this effectively?

only by creating a new tab? Starting from the last row? As I change the range while iterating.

  for ( i = 0; i < lastColumn - 1; i++){     for ( j = 0 ; j < lastRow - 1; j++){       var kw_data = kw_to_label[rangeValues[j][i]];         if(kw_data != null){         sheet.getRange(j,i).setValue(kw_data.labels[k]);   

An example:

dict: k1 -> val1, val2 k2 -> val3 

and sheet:

Is it possible through the Google Adwords v201809 API to get data on Sitelink extensions?

I haven't seen that as one of the available reports.

Thanks, Jared

I am developing a B2C application for local business. I will be developing separate apps for businesses and customers but to cater to the customers who do not have the app yet, I wish to provide Businesses with the functionality that they can send invoices to their customer's WhatsApp through my Business App from their WhatsApp Number.

How can I achieve this?

Thanks in advance

Installed whatasppp Business api followed the link https://developers.facebook.com/docs/whatsapp/installation

Logged into https://localhost:9090/

For registration, it requires a phone number and a certificate.

Setup the Whatsapp Business APP for phone number then added the number in Facebook business manager.

However, couldn't acquire the cerificate to complete the registration. There are instructions in the link https://developers.facebook.com/docs/whatsapp/api/account but couldn't follow it, there is no settings tab or whatsapp manager button to acquire the certificate as mentioned in 3rd point.

1. Go to the Business Settings in your Facebook Business Manager.
2. Click on WhatsApp Accounts under the Accounts menu, then select your WhatsApp Account from the WhatsApp Accounts list, if it isn't already highlighted.
3. Go to the Settings tab, and click the WhatsApp Manager button.
4. Under the Phone Numbers tab, you should see your phone numbers listed. Click the View button of the phone number you want the certificate for.

Useful Links

Embedded

https://www.facebook.com/business/help/2640149499569241

Direct - Intended for people developing applications for themselves or their organization

https://developers.facebook.com/docs/whatsapp/cloud-api/get-started

Verification

https://www.youtube.com/watch?v=Gtj82ugi-bI