Extension site-links upload Google Ads API ERROR

[Luka Brkanovic]

Hello,

we are having problems with our python script for uploading  extension - sitelinks for campaigns, the script was running just fine until last week, here is the code of functions, as well as the thrown ERROR  below:

def main(client, customer_id, connection):
"""Adds sitelinks to a campaign using assets.

Args:
client: The Google Ads client.
customer_id: The customer ID for which to add the keyword.
campaign_id: The campaign to which sitelinks will be added.
"""
# select_docs = f"""SELECT `id`, `doctor_id` FROM `doctors-promoted` WHERE `merged_account` = 6 AND 'm' NOT IN (SELECT `ext_sitelink` FROM `aw_mp_campaigns` WHERE `doctor_id` = `doctors-promoted`.`doctor_id`)"""
#mixed
select_docs = f"""SELECT `id`, `doctor_id` FROM `doctors-promoted` WHERE 'n' IN (SELECT `ext_sitelink` FROM `aw_mp_campaigns` WHERE `doctor_id` = `doctors-promoted`.`doctor_id`) AND `is_sbox` = 'y'"""
try:
select_docs_response = execute_read_query(connection, select_docs)
except Error as ex:
print("DB ERROR OCCURRED:")
print(ex.msg)
sys.exit(1)
for item in select_docs_response:
select_url = f"""SELECT `final_url` FROM `doctors-active` WHERE `doctor_id` = {item[1]}"""
try:
select_url_response = execute_read_query(connection, select_url)
except Error as ex:
print("DB ERROR OCCURRED:")
print(ex.msg)
sys.exit(1)
resource_names = _create_sitelink_assets(client, customer_id, select_url_response[0][0])
select_campaigns = f"""SELECT `id`, `aw_id` FROM `aw_mp_campaigns` WHERE `doctor_id` = {item[1]} AND `name` LIKE '%[%'"""
try:
select_campaigns_response = execute_read_query(connection, select_campaigns)
except Error as ex:
print("DB ERROR OCCURRED:")
print(ex.msg)
sys.exit(1)
for sub in select_campaigns_response:
_link_sitelinks_to_campaign(
client, customer_id, sub[1], resource_names
)
update_campaign_in_db= f"""UPDATE `aw_mp_campaigns` SET `ext_sitelink` = 'y' WHERE `id` = {sub[0]}"""
try:
execute_query(connection, update_campaign_in_db)
except Error as ex:
print("DB ERROR OCCURRED:")
print(ex.msg)
sys.exit(1)



# Creates sitelink assets.

# Associates the sitelinks at the campaign level.




def _create_sitelink_assets(client, customer_id, doc_url):
"""Creates sitelink assets, which can be added to campaigns.

Args:
client: The Google Ads client.
customer_id: The customer ID for which to add the keyword.
campaign_id: The campaign to which sitelinks will be added.

Returns:
a list of sitelink asset resource names.
"""
sitelink1_operation = client.get_type("AssetOperation")
sitelink1_asset = sitelink1_operation.create
url1 = doc_url + "#tab=profile-info"
sitelink1_asset.final_urls.append(url1)
sitelink1_asset.sitelink_asset.link_text = "Consultórios"

sitelink2_operation = client.get_type("AssetOperation")
sitelink2_asset = sitelink2_operation.create
url2 = doc_url + "#tab=profile-pricing"
sitelink2_asset.final_urls.append(url2)
sitelink2_asset.sitelink_asset.link_text = "Serviços"

sitelink3_operation = client.get_type("AssetOperation")
sitelink3_asset = sitelink3_operation.create
url3 = doc_url + "#tab=profile-experience"
sitelink3_asset.final_urls.append(url3)
sitelink3_asset.sitelink_asset.link_text = "Experiência"


asset_service = client.get_service("AssetService")
response = asset_service.mutate_assets(
customer_id=customer_id,
operations=[
sitelink1_operation,
sitelink2_operation,
sitelink3_operation,
],
)

resource_names = [result.resource_name for result in response.results]

for resource_name in resource_names:
print(f"Created sitelink asset with resource name '{resource_name}'.")

return resource_names


def _link_sitelinks_to_campaign(
client, customer_id, campaign_id, resource_names
):
"""Creates sitelink assets, which can be added to campaigns.

Args:
client: The Google Ads client.
customer_id: The customer ID for which to add the keyword.
campaign_id: The campaign to which sitelinks will be added.
resource_names: a list of sitelink asset resource names.
"""
campaign_service = client.get_service("CampaignService")
operations = []
for resource_name in resource_names:
operation = client.get_type("CampaignAssetOperation")
campaign_asset = operation.create
campaign_asset.asset = resource_name
campaign_asset.campaign = campaign_service.campaign_path(
customer_id, campaign_id
)
campaign_asset.field_type = client.enums.AssetFieldTypeEnum.SITELINK
operations.append(operation)

campaign_asset_service = client.get_service("CampaignAssetService")
response = campaign_asset_service.mutate_campaign_assets(
customer_id=customer_id, operations=operations
)

for result in response.results:
print(
"Linked sitelink to campaign with resource name '{result.resource_name}'."
)

ERROR:

Request made: ClientCustomerId: 2611122037, Host: googleads.googleapis.com, Method: /google.ads.googleads.v9.services.CampaignAssetService/MutateCampaignAssets, RequestId: K7VMZSMq6kPosrj8gnRfsw, IsFault: True, FaultMessage: This request would exceed a limit on the number of allowed resources. The details of which type of limit was exceeded will eventually be returned in ErrorDetails. Request with ID 'K7VMZSMq6kPosrj8gnRfsw' failed with status 'INVALID_ARGUMENT' and includes the following errors:    Error with message 'This request would exceed a limit on the number of allowed resources. The details of which type of limit was exceeded will eventually be returned in ErrorDetails.'.        On field: operations

Thanks for your help.

Best,
Luka

[Google Ads API Forum Advisor]

Hi Luka,

You may have hit the limit of sitelinks per campaign. To find out what is going on, you can turn on logging with log level set to 'DEBUG' and send us privately the log of request and response communication with the API when getting this error.

The request and response appears similar to the JSON Mappings in our REST documentation with additional headers and information such as request Id.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2aqyuo:ref