It's hard to debug because it's not clear what req...
# troubleshootingd
dashiq_team
05/12/2023, 12:56 AMIt's hard to debug because it's not clear what request Meltano is sending to the API
a
aaron_phethean
05/12/2023, 6:28 AMWe’ll take a look, but in the meantime you could dig into the code if you wanted to: https://github.com/Matatika/tap-googleads
d
dashiq_team
05/12/2023, 2:26 PMI did, it's doing a POST request, so it might be something else
dashiq_team
05/12/2023, 2:33 PMI tried the same Query in Postman, this is the result
dashiq_team
05/12/2023, 2:33 PM Copy code
"error": {
"code": 400,
"message": "Request contains an invalid argument.",
"status": "INVALID_ARGUMENT",
"details": [
{
"@type": "<http://type.googleapis.com/google.ads.googleads.v13.errors.GoogleAdsFailure|type.googleapis.com/google.ads.googleads.v13.errors.GoogleAdsFailure>",
"errors": [
{
"errorCode": {
"queryError": "REQUESTED_METRICS_FOR_MANAGER"
},
"message": "Metrics cannot be requested for a manager account. To retrieve metrics, issue separate requests against each client account under the manager account."
}
],
"requestId": "S13xs78x2XigEvlOW5LMuQ"
}
]
}
}dashiq_team
05/12/2023, 2:36 PMbut if I change the Customer ID and use one of the sub-account, I get
Copy code
singer_sdk.exceptions.FatalAPIError: 403 Client Error: Forbidden for path: /v12/customers/1747437642/googleAds:searcha
aaron_phethean
05/12/2023, 4:12 PMHi Mauro, the Matatika tap was originally a fork of Derek's good work (https://github.com/AutoIDM/tap-googleads). Hardened a bit and OAuth was added so we could get a drop-down of the customer ids in our Lab (also a Meltano plugin (https://hub.meltano.com/utilities/matatika)
d
dashiq_team
05/13/2023, 4:07 PMOk, so adding login-customer-id header with the Manager id and performing the call using the sub account works, so the only thing that is missing is the login-customer-id header I guess
dashiq_team
05/13/2023, 4:07 PMCan I add custom header?
dashiq_team
05/13/2023, 4:26 PMlooks like Derek's original tap has it
dashiq_team
05/13/2023, 4:26 PMlogin_customer_id: Customer ID that has access to the customer_id, note that they can be the same, but they don't have to be as this could be a Manager account
dashiq_team
05/13/2023, 4:26 PMI'll try that!
dashiq_team
05/13/2023, 6:52 PMIt works!!