At the moment, the only option for adding and removing placements and other targeting options for YouTube items is by generating and manually uploading SDFs through the console. Please extend the DV360 API's current capabilities and options to include YouTube as well.

Hi there,

We are currently running a small two-day test in DV360 to see if our setup is working correctly. However, the script is now failing and I'm getting the below error in the logs.

Error: {
  "error": {
    "code": 400,
    "message": "When a flight/budget segment date is updated, the new value cannot be in the past.",
    "status": "INVALID_ARGUMENT"
  }
}

When I looked at the code I don't think we're updating the flight dates, only the Active/Paused status.

So is the error occurring because the flight end date is today (29/07/2021) and that is considered as "in the past" already?

Only checking the weather works perfectly fine, but when I want to synch with DV360 I always get this error: TypeError: Cannot read property '0' of undefined

extract method? the current one gets too long

Originally posted by @kubarozek-google in #7 (comment)

Getting this error when I try to "Only check weather"

A colleague came to me because this script was giving errors. He deployed the solution, but he ended up with multiple sheets - I have no idea how he managed that. Funny enough, menu function "Only check weather" works as advertised. But running "Check weather and sync DV360" gives this error in the log:

TypeError: Cannot read property '0' of undefined
    at forceFormulasEval(Code:505:59)
    at main(Code:1712:41)
    at monitorWeatherAndSyncWithDV360(Code:1762:12)

The problem: function forceFormulasEval assumes the default sheet to be the Triggers sheet. Applying the following change will fix the problem:

  forceFormulasEval(row, col) {
    //return this.get(`R${row}C${col}`, 'UNFORMATTED_VALUE')[0][0];
    return this.get(`${configSpreadsheetName}!R${row}C${col}`, 'UNFORMATTED_VALUE')[0][0];
  }

Only checking the weather works at first, when I try to sync with DV360 I get the following error:
"Failed to read to sheet after 7 retries"
Afterwards weather check only won't work too

Actual result: When the API output of 0 value is processed and saved into the spreadsheet cell it is saved as an empty string.
Expected result: It should be saved as a number, e.g. "0".