Error Parsing "Start Date" Column for BulkAssetGroup

[VadimSaratov]

When attempting to download and parse the BulkAssetGroup object, the SDK throws an error related to the Start Date column.

[ERROR] [BulkServiceManager.EntityReadException] Couldn't parse column Start Date of <class 'bingads.v13.bulk.entities.bulk_asset_group.BulkAssetGroup'> entity: unconverted data remains:  00:00:00 See ColumnValues for detailed row information and InnerException for error details.

It cannot process the Start Date column when the format is YYYY-MM-DD HH:MM:SS. It appears the BulkAssetGroup expects the date format to be YYYY-MM-DD
Probably the same issue with End Date

Or is it a bug with CSV generation?

If the issue is the date format, then
Suggested Fix:
Update the BulkAssetGroup to handle datetime formats in the Start Date and End Date columns.

        _SimpleBulkMapping(
            header=_StringTable.StartDate,
            field_to_csv=lambda c: bulk_datetime_str(c.asset_group.StartDate),
            csv_to_field=lambda c, v: setattr(c.asset_group, 'StartDate', parse_datetime(v))
        ),
        _SimpleBulkMapping(
            header=_StringTable.EndDate,
            field_to_csv=lambda c: bulk_datetime_str(c.asset_group.EndDate),
            csv_to_field=lambda c, v: setattr(c.asset_group, 'EndDate', parse_datetime(v))
        ),

Environment:

• SDK Version: v13.0.21.2
• Python Version: Python 3.11

Let me know if you'd like any further refinements!

[xinyuwen2]

We only support Year-Month-Day for Asset Group Date. Please check the bulk schema here. (https://learn.microsoft.com/en-us/advertising/bulk-service/asset-group?view=bingads-13#startdate)

Date type definition. (https://learn.microsoft.com/en-us/advertising/campaign-management-service/date?view=bingads-13&tabs=xml)

[VadimSaratov]

@xinyuwen2 then probably something is wrong with the csv file, since I'm getting Start Date 11/18/2024 00:00:00

[VadimSaratov]

hi @xinyuwen2
I'm still encountering an issue when trying to read a file containing BulkAssetGroup entities (tested with both TSV and CSV formats) using the latest version of the SDK v13.0.25.1
Error:

 bingads.v13.bulk.exceptions.EntityReadException: Couldn't parse column Start Date of <class 'bingads.v13.bulk.entities.bulk_asset_group.BulkAssetGroup'> entity: unconverted data remains:  00:00:00 See ColumnValues for detailed row information and InnerException for error details.

It seems like the SDK fails to handle the "Start Date" field when it includes a time portion 00:00:00

Code snippet used to read the bulk file:

from bingads.v13.bulk import enums, file_reader

bulk_file_path = "/path/to/my-bulk-file.csv"  # Also tested with 'Tsv'

with file_reader.BulkFileReader(
    file_path=bulk_file_path,
    result_file_type=enums.ResultFileType.full_download,
    file_type='Csv'  # Also tested with 'Tsv'
) as reader:
    for entity in reader:
        print(entity)

Would appreciate any workaround or fix.

Thanks!