How to update MySql table using json data with python dictionaries?

Question

I am getting an error while inserting data from python dictionary to mysql table. I have attached error details and code below. I am getting error like this 'mysql.connector.errors.DataError: 1292 (22007): Incorrect date value: '[value-13]' for column newdb.job_listings.posted_date at row 1'

import requests
import uuid
import mysql.connector
headers = {
    'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36',
    'Referer' : 'https://www.hirist.com/',
    'Authorization' : 'Bearer undefined',
    'Origin' : 'https://www.hirist.com',
}
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="",
  database='newDB'
 

)
mycursor = mydb.cursor()
payload = {
    "pageNo" : "1",
    "query" : "software engineer",
    "loc" : '17',
    "minexp" : '0',
    "maxexp" : '0',
    "range" : '0',
    "boost" : '0',
    "searchRange" : '4',
    "searchOp" : 'AND',
    "jobType" : "1"
}

jsonData = requests.get("https://jobseeker-api.hirist.com/jobfeed/-1/search", 
                        headers=headers, params=payload, verify=False).json()
for job in jsonData['jobs']:
    print(job['id'],job['jobdesignation'],job['jobDetailUrl'],job['locations'][0]['name'],job['companyData']['companyName'])

    row={
            'job_listing_id':job['id'], #job_listing_id
            'unique_hash':str(uuid.uuid4()), # Unique Hash
            'status':'NEW',#status
            'primary_skills':'',#primary_skills\            
            'secondary_skills':'',#secondary_skills
            'title':job['jobdesignation'],  # Job title6
            'description':job['introText'] ,#description`
            'job_type':1,#job_type
            'source':'NA', #source
            'experience':'',#EXp
            'location':job['locations'][0]['name'],#Location
            'company':job['companyData']['companyName'],#company
            'posted_date':'',  # posted on
            'expiryDate':'', #expiryDate
            'vacancies':'',#vacancies
            'company_website':job['jobDetailUrl'],#company_website
            'posted_by':'Hirist'#posted_by
        }

    sql = "INSERT INTO job_listings(`job_listing_id`, `unique_hash`, `status`, `primary_skills`, `secondary_skills`, `title`, `description`, `job_type`, `source`, `experience`, `location`, `company`, `posted_date`, `expiryDate`, `vacancies`, `company_website`, `posted_by`) VALUES (767,'[value-2]','[value-3]','[value-4]','[value-5]','[value-6]','[value-7]','[value-8]','[value-9]','[value-10]','[value-11]','[value-12]','[value-13]','[value-14]','[value-15]','[value-16]','[value-17]')"

    mycursor.execute(sql, row)
mydb.commit()