System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:1792bf5d-8253-4af2-bb62-9beeb89df983
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90572 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90572,1,'{"status":"ok","response":{"mid":90572,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Harbour Diamonds won by 5 wickets","day_remaining_over":"","team_batting":"Harbour Diamonds","team_bowling":"Rashmi Medinipur Wizards","live_inning_number":2,"live_score":{"runs":130,"overs":17.5,"wickets":5,"target":128,"runrate":7.29,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Prayas Ray Barman","batsman_id":94087,"runs":10,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"200.00"},{"name":"Badal Singh-Balyan","batsman_id":140355,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Akash Ghatak","bowler_id":120630,"overs":1.5,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"14.18"},{"name":"Raj Kumar Pal","bowler_id":97073,"overs":4,"runs_conceded":26,"wickets":3,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12174269","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"13","ball":"4","score":0,"commentary":"Raj Kumar Pal to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750354496,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174272","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"13","ball":"5","score":1,"commentary":"Raj Kumar Pal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354498,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174277","event":"ball","batsman_id":"120530","bowler_id":"97073","over":"13","ball":"6","score":1,"commentary":"Raj Kumar Pal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354515,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":5,"score":"88\/3","bats":[{"runs":22,"balls_faced":22,"fours":2,"sixes":0,"batsman_id":120530},{"runs":8,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":104502}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":97073,"overs":3},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":146312,"overs":1}],"commentary":"End of over 14 (5 runs), Harbour Diamonds 88\/3"},{"event_id":"12174286","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"1","score":1,"commentary":"Soumyadip Mandal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354599,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174289","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"2","score":1,"commentary":"Soumyadip Mandal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354602,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174309","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"3","score":1,"commentary":"Soumyadip Mandal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354722,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174310","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"4","score":6,"commentary":"Soumyadip Mandal to Subham Sarkar, Six,","noball_dismissal":false,"text":"","timestamp":1750354725,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12174317","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"5","score":1,"commentary":"Soumyadip Mandal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354868,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174329","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"6","score":6,"commentary":"Soumyadip Mandal to Chandrahas Dash, Six,","noball_dismissal":false,"text":"","timestamp":1750354870,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":15,"runs":16,"score":"104\/3","bats":[{"runs":30,"balls_faced":25,"fours":2,"sixes":1,"batsman_id":120530},{"runs":16,"balls_faced":15,"fours":0,"sixes":1,"batsman_id":104502}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":146312,"overs":2},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":97073,"overs":3}],"commentary":"End of over 15 (16 runs), Harbour Diamonds 104\/3"},{"event_id":"12174350","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"1","score":1,"commentary":"Vaibhav Yadav to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355016,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174352","event":"ball","batsman_id":"120530","bowler_id":"110055","over":"15","ball":"2","score":1,"commentary":"Vaibhav Yadav to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355019,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174353","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"3","score":"1wd","commentary":"Vaibhav Yadav to Subham Sarkar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750355022,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12174362","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"3","score":2,"commentary":"Vaibhav Yadav to Subham Sarkar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750355067,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174365","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"4","score":0,"commentary":"Vaibhav Yadav to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750355070,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174387","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"5","score":0,"commentary":"Vaibhav Yadav to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750355282,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174391","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"6","score":1,"commentary":"Vaibhav Yadav to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355288,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"110\/3","bats":[{"runs":20,"balls_faced":20,"fours":0,"sixes":1,"batsman_id":104502},{"runs":31,"balls_faced":26,"fours":2,"sixes":1,"batsman_id":120530}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":110055,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":146312,"overs":2}],"commentary":"End of over 16 (6 runs), Harbour Diamonds 110\/3"},{"event_id":"12174421","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"1","score":6,"commentary":"Raj Kumar Pal to Subham Sarkar, Six,","noball_dismissal":false,"text":"","timestamp":1750355474,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12174422","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"2","score":2,"commentary":"Raj Kumar Pal to Subham Sarkar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750355477,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174424","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"3","score":1,"commentary":"Raj Kumar Pal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355479,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174428","event":"wicket","batsman_id":"120530","bowler_id":"97073","over":"16","ball":"4","score":"w","commentary":"Raj Kumar Pal to Chandrahas Dash, no run, c Ranjot Singh Khaira b RK Pal,","noball_dismissal":false,"text":"","timestamp":1750355497,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"120530","how_out":"c Ranjot Singh Khaira b RK Pal","batsman_runs":"31","batsman_balls":"27"},{"event_id":"12174446","event":"ball","batsman_id":"94087","bowler_id":"97073","over":"16","ball":"5","score":1,"commentary":"Raj Kumar Pal to Prayas Ray Barman, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355615,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174448","event":"wicket","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"6","score":"w","commentary":"Raj Kumar Pal to Subham Sarkar, no run, c Ranjot Singh Khaira b RK Pal,","noball_dismissal":false,"text":"","timestamp":1750355657,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"104502","how_out":"c Ranjot Singh Khaira b RK Pal","batsman_runs":"29","batsman_balls":"24"},{"event":"overend","over":17,"runs":10,"score":"120\/5","bats":[{"runs":29,"balls_faced":24,"fours":0,"sixes":2,"batsman_id":104502},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":94087}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":97073,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":110055,"overs":4}],"commentary":"End of over 17 (10 runs), Harbour Diamonds 120\/5"},{"event_id":"12174467","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"1","score":4,"commentary":"Akash Ghatak to Prayas Ray Barman, Four,","noball_dismissal":false,"text":"","timestamp":1750355795,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12174471","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"2","score":0,"commentary":"Akash Ghatak to Prayas Ray Barman, no run,","noball_dismissal":false,"text":"","timestamp":1750355798,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174477","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"3","score":1,"commentary":"Akash Ghatak to Prayas Ray Barman, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355866,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174484","event":"ball","batsman_id":"140355","bowler_id":"120630","over":"17","ball":"4","score":1,"commentary":"Akash Ghatak to Badal Singh-Balyan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355902,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174487","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"5","score":4,"commentary":"Akash Ghatak to Prayas Ray Barman, Four,","noball_dismissal":false,"text":"","timestamp":1750356948,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198382,"number":2,"name":"Harbour Diamonds Inning","short_name":"HD Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128511,"fielding_team_id":128513,"scores":"130\/5","scores_full":"130\/5 (17.5 ov)","fielder":[{"fielder_id":"55706","fielder_name":"Vivek Singh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"111826","fielder_name":"Ranjot Singh Khaira","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Subham Sarkar","batsman_id":"104502","runs":"29","balls":"24","how_out":"c Ranjot Singh Khaira b RK Pal","score_at_dismissal":120,"overs_at_dismissal":"16.6","bowler_id":"97073","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":130,"wickets":5,"overs":"17.5","bowlers_used":6,"runrate":"7.29"},"current_partnership":{"runs":10,"balls":5,"overs":0.5,"batsmen":[{"name":"Prayas Ray Barman","batsman_id":94087,"runs":9,"balls":4},{"name":"Badal Singh-Balyan","batsman_id":140355,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"108858","name":"Priyank Patel"},{"player_id":"681","name":"Manoj Tiwary"},{"player_id":"149800","name":"Pradeep Kumar"},{"player_id":"97072","name":"Geet Puri"},{"player_id":"48568","name":"Kaushik Maity"}],"max_over":"18","target":"128","recent_scores":"4,1,1,0,4,w,1,w,1,2,6,1,0,0,2,1,1,1","last_five_overs":"48\/2 9.29","last_ten_overs":"78\/3 7.55"},"teams":[{"tid":128511,"title":"Harbour Diamonds","abbr":"HD","alt_name":"Harbour Diamonds","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"130\/5 (17.5 ov)","scores":"130\/5","overs":"17.5"},{"tid":128513,"title":"Rashmi Medinipur Wizards","abbr":"RMW","alt_name":"Rashmi Medinipur Wizards","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/9 (18 ov)","scores":"127\/9","overs":"18"}],"players":[{"pid":681,"title":"Manoj Tiwary","short_name":"M Tiwary","first_name":"Manoj Tiwary","last_name":"","middle_name":"","birthdate":"1985-11-14","birthplace":"Howrah, Bengal","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/ManojTiwaryOfficial","twitter_profile":"https:\/\/twitter.com\/tiwarymanoj","instagram_profile":"https:\/\/www.instagram.com\/mannirocks14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":48568,"title":"Kaushik Maity","short_name":"Kaushik Maity","first_name":"Kaushik Maity","last_name":"","middle_name":"","birthdate":"1999-10-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":53501,"title":"Sudip Chatterjee","short_name":"SD Chatterjee","first_name":"Sudip Chatterjee","last_name":"","middle_name":"","birthdate":"1991-11-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sudipchatterjee06\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":54418,"title":"Abhimanyu Easwaran","short_name":"A Easwaran","first_name":"Abhimanyu Easwaran","last_name":"","middle_name":"","birthdate":"1995-09-06","birthplace":" Dehradun","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"https:\/\/www.facebook.com\/Abhimanyueaswaranofficial\/","twitter_profile":"https:\/\/twitter.com\/AbhimanyuEaswa1","instagram_profile":"https:\/\/www.instagram.com\/easwaranabhimanyu1\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":54537,"title":"Sandipan Das","short_name":"S Das","first_name":"Sandipan Das","last_name":"","middle_name":"","birthdate":"1992-11-29","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":55706,"title":"Vivek Singh","short_name":"V Singh","first_name":"Vivek Singh","last_name":"","middle_name":"","birthdate":"1993-11-01","birthplace":"Howrah","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":55769,"title":"Ritwik Roy Chowdhury","short_name":"R Chowdhury","first_name":"Ritwik Roy Chowdhury","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":90396,"title":"Pankaj Shaw","short_name":"PP Shaw","first_name":"Pankaj Shaw","last_name":"","middle_name":"","birthdate":"1988-02-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":90520,"title":"Abhishek Raman","short_name":"A Raman","first_name":"Abhishek Raman","last_name":"","middle_name":"","birthdate":"1993-09-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":94087,"title":"Prayas Ray Barman","short_name":"P Ray Barman","first_name":"Prayas Ray Barman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":97072,"title":"Geet Puri","short_name":"G Puri","first_name":"Geet Puri","last_name":"","middle_name":"","birthdate":"1994-11-06","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":97073,"title":"Raj Kumar Pal","short_name":"RK Pal","first_name":"Raj Kumar Pal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":103183,"title":"Rahul Prasad","short_name":"R Prasad","first_name":"Rahul Prasad","last_name":"","middle_name":"","birthdate":"2004-10-13","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":104502,"title":"Subham Sarkar","short_name":"S Sarkar","first_name":"Subham Sarkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":104506,"title":"Prakash KR Roy","short_name":"P KR Roy","first_name":"Prakash KR Roy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":104530,"title":"Dipanjan Mukherjee","short_name":"D Mukherjee","first_name":"Dipanjan Mukherjee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":108858,"title":"Priyank Patel","short_name":"P Patel","first_name":"Priyank Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":110055,"title":"Vaibhav Yadav","short_name":"V Yadav","first_name":"Vaibhav Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":111826,"title":"Ranjot Singh Khaira","short_name":"Ranjot Singh Khaira","first_name":"Ranjot Singh Khaira","last_name":"","middle_name":"","birthdate":"1998-10-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":112723,"title":"Aishik Patel","short_name":"A Patel","first_name":"Aishik Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112739,"title":"Kaushik Giri","short_name":"K Giri","first_name":"Kaushik Giri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112765,"title":"Rahul Kundu","short_name":"R Kundu","first_name":"Rahul Kundu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":120530,"title":"Chandrahas Dash","short_name":"C Dash","first_name":"Chandrahas Dash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":120630,"title":"Akash Ghatak","short_name":"A Ghatak","first_name":"Akash Ghatak","last_name":"","middle_name":"","birthdate":"1996-10-13","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/akash.ghatak.92\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akashghatak16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":127126,"title":"Sourav Halder","short_name":"S Halder","first_name":"Sourav Halder","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":140341,"title":"Rahul Gupta","short_name":"R Gupta","first_name":"Rahul Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140344,"title":"Vishal Bhati","short_name":"V Bhati","first_name":"Vishal Bhati","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140355,"title":"Badal Singh-Balyan","short_name":"BS-Balyan","first_name":"Badal Singh-Balyan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":140360,"title":"Balkesh Yadav","short_name":"B Yadav","first_name":"Balkesh Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140370,"title":"Priyanshu Gaurav Srivastav","short_name":"PG Srivastav","first_name":"Priyanshu Gaurav Srivastav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140372,"title":"Ayush Ghosh","short_name":"A Ghosh","first_name":"Ayush Ghosh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":146312,"title":"Soumyadip Mandal","short_name":"S Mandal","first_name":"Soumyadip Mandal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149698,"title":"Jagmohan Prasad Gupta","short_name":"J Prasad Gupta","first_name":"Jagmohan Prasad Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149800,"title":"Pradeep Kumar","short_name":"P Kumar","first_name":"Pradeep Kumar","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149801,"title":"Vijay Srivastava","short_name":"V Srivastava","first_name":"Vijay Srivastava","last_name":"","middle_name":"","birthdate":"2007-10-25","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"d40bce2eb84e293e7851b81ea4a1cea4","modified":"2025-06-27 03:08:26","datetime":"2025-06-27 03:08:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90572,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Harbour Diamonds won by 5 wickets","day_remaining_over":"","team_batting":"Harbour Diamonds","team_bowling":"Rashmi Medinipur Wizards","live_inning_number":2,"live_score":{"runs":130,"overs":17.5,"wickets":5,"target":128,"runrate":7.29,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Prayas Ray Barman","batsman_id":94087,"runs":10,"balls_faced":5,"fours":2,"sixes":0,"strike_rate":"200.00"},{"name":"Badal Singh-Balyan","batsman_id":140355,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"}],"bowlers":[{"name":"Akash Ghatak","bowler_id":120630,"overs":1.5,"runs_conceded":26,"wickets":0,"maidens":0,"econ":"14.18"},{"name":"Raj Kumar Pal","bowler_id":97073,"overs":4,"runs_conceded":26,"wickets":3,"maidens":0,"econ":"6.50"}],"commentaries":[{"event_id":"12174269","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"13","ball":"4","score":0,"commentary":"Raj Kumar Pal to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750354496,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174272","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"13","ball":"5","score":1,"commentary":"Raj Kumar Pal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354498,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174277","event":"ball","batsman_id":"120530","bowler_id":"97073","over":"13","ball":"6","score":1,"commentary":"Raj Kumar Pal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354515,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":14,"runs":5,"score":"88\/3","bats":[{"runs":22,"balls_faced":22,"fours":2,"sixes":0,"batsman_id":120530},{"runs":8,"balls_faced":12,"fours":0,"sixes":0,"batsman_id":104502}],"bowls":[{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":97073,"overs":3},{"runs_conceded":6,"maidens":0,"wickets":0,"bowler_id":146312,"overs":1}],"commentary":"End of over 14 (5 runs), Harbour Diamonds 88\/3"},{"event_id":"12174286","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"1","score":1,"commentary":"Soumyadip Mandal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354599,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174289","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"2","score":1,"commentary":"Soumyadip Mandal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354602,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174309","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"3","score":1,"commentary":"Soumyadip Mandal to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354722,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174310","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"4","score":6,"commentary":"Soumyadip Mandal to Subham Sarkar, Six,","noball_dismissal":false,"text":"","timestamp":1750354725,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12174317","event":"ball","batsman_id":"104502","bowler_id":"146312","over":"14","ball":"5","score":1,"commentary":"Soumyadip Mandal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750354868,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174329","event":"ball","batsman_id":"120530","bowler_id":"146312","over":"14","ball":"6","score":6,"commentary":"Soumyadip Mandal to Chandrahas Dash, Six,","noball_dismissal":false,"text":"","timestamp":1750354870,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event":"overend","over":15,"runs":16,"score":"104\/3","bats":[{"runs":30,"balls_faced":25,"fours":2,"sixes":1,"batsman_id":120530},{"runs":16,"balls_faced":15,"fours":0,"sixes":1,"batsman_id":104502}],"bowls":[{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":146312,"overs":2},{"runs_conceded":16,"maidens":0,"wickets":1,"bowler_id":97073,"overs":3}],"commentary":"End of over 15 (16 runs), Harbour Diamonds 104\/3"},{"event_id":"12174350","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"1","score":1,"commentary":"Vaibhav Yadav to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355016,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174352","event":"ball","batsman_id":"120530","bowler_id":"110055","over":"15","ball":"2","score":1,"commentary":"Vaibhav Yadav to Chandrahas Dash, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355019,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174353","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"3","score":"1wd","commentary":"Vaibhav Yadav to Subham Sarkar, 1 wide,","noball_dismissal":false,"text":"","timestamp":1750355022,"run":1,"noball_run":"0","wide_run":"1","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":true,"six":false,"four":false,"freehit":false},{"event_id":"12174362","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"3","score":2,"commentary":"Vaibhav Yadav to Subham Sarkar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750355067,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174365","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"4","score":0,"commentary":"Vaibhav Yadav to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750355070,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174387","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"5","score":0,"commentary":"Vaibhav Yadav to Subham Sarkar, no run,","noball_dismissal":false,"text":"","timestamp":1750355282,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174391","event":"ball","batsman_id":"104502","bowler_id":"110055","over":"15","ball":"6","score":1,"commentary":"Vaibhav Yadav to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355288,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event":"overend","over":16,"runs":6,"score":"110\/3","bats":[{"runs":20,"balls_faced":20,"fours":0,"sixes":1,"batsman_id":104502},{"runs":31,"balls_faced":26,"fours":2,"sixes":1,"batsman_id":120530}],"bowls":[{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":110055,"overs":4},{"runs_conceded":22,"maidens":0,"wickets":0,"bowler_id":146312,"overs":2}],"commentary":"End of over 16 (6 runs), Harbour Diamonds 110\/3"},{"event_id":"12174421","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"1","score":6,"commentary":"Raj Kumar Pal to Subham Sarkar, Six,","noball_dismissal":false,"text":"","timestamp":1750355474,"run":6,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"6","noball":false,"wideball":false,"six":true,"four":false,"freehit":false},{"event_id":"12174422","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"2","score":2,"commentary":"Raj Kumar Pal to Subham Sarkar, 2 runs,","noball_dismissal":false,"text":"","timestamp":1750355477,"run":2,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"2","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174424","event":"ball","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"3","score":1,"commentary":"Raj Kumar Pal to Subham Sarkar, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355479,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174428","event":"wicket","batsman_id":"120530","bowler_id":"97073","over":"16","ball":"4","score":"w","commentary":"Raj Kumar Pal to Chandrahas Dash, no run, c Ranjot Singh Khaira b RK Pal,","noball_dismissal":false,"text":"","timestamp":1750355497,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"120530","how_out":"c Ranjot Singh Khaira b RK Pal","batsman_runs":"31","batsman_balls":"27"},{"event_id":"12174446","event":"ball","batsman_id":"94087","bowler_id":"97073","over":"16","ball":"5","score":1,"commentary":"Raj Kumar Pal to Prayas Ray Barman, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355615,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174448","event":"wicket","batsman_id":"104502","bowler_id":"97073","over":"16","ball":"6","score":"w","commentary":"Raj Kumar Pal to Subham Sarkar, no run, c Ranjot Singh Khaira b RK Pal,","noball_dismissal":false,"text":"","timestamp":1750355657,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false,"wicket_batsman_id":"104502","how_out":"c Ranjot Singh Khaira b RK Pal","batsman_runs":"29","batsman_balls":"24"},{"event":"overend","over":17,"runs":10,"score":"120\/5","bats":[{"runs":29,"balls_faced":24,"fours":0,"sixes":2,"batsman_id":104502},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":94087}],"bowls":[{"runs_conceded":26,"maidens":0,"wickets":3,"bowler_id":97073,"overs":4},{"runs_conceded":21,"maidens":0,"wickets":1,"bowler_id":110055,"overs":4}],"commentary":"End of over 17 (10 runs), Harbour Diamonds 120\/5"},{"event_id":"12174467","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"1","score":4,"commentary":"Akash Ghatak to Prayas Ray Barman, Four,","noball_dismissal":false,"text":"","timestamp":1750355795,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false},{"event_id":"12174471","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"2","score":0,"commentary":"Akash Ghatak to Prayas Ray Barman, no run,","noball_dismissal":false,"text":"","timestamp":1750355798,"run":0,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"0","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174477","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"3","score":1,"commentary":"Akash Ghatak to Prayas Ray Barman, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355866,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174484","event":"ball","batsman_id":"140355","bowler_id":"120630","over":"17","ball":"4","score":1,"commentary":"Akash Ghatak to Badal Singh-Balyan, 1 run,","noball_dismissal":false,"text":"","timestamp":1750355902,"run":1,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"1","noball":false,"wideball":false,"six":false,"four":false,"freehit":false},{"event_id":"12174487","event":"ball","batsman_id":"94087","bowler_id":"120630","over":"17","ball":"5","score":4,"commentary":"Akash Ghatak to Prayas Ray Barman, Four,","noball_dismissal":false,"text":"","timestamp":1750356948,"run":4,"noball_run":"0","wide_run":"0","bye_run":"0","legbye_run":"0","bat_run":"4","noball":false,"wideball":false,"six":false,"four":true,"freehit":false}],"day":"0","session":"0","live_inning":{"iid":198382,"number":2,"name":"Harbour Diamonds Inning","short_name":"HD Inning","status":2,"issuperover":"false","result":3,"batting_team_id":128511,"fielding_team_id":128513,"scores":"130\/5","scores_full":"130\/5 (17.5 ov)","fielder":[{"fielder_id":"55706","fielder_name":"Vivek Singh","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":1,"is_substitute":"false"},{"fielder_id":"111826","fielder_name":"Ranjot Singh Khaira","catches":2,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":{"p1":{"startover":"0.1","endover":"6"}},"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Subham Sarkar","batsman_id":"104502","runs":"29","balls":"24","how_out":"c Ranjot Singh Khaira b RK Pal","score_at_dismissal":120,"overs_at_dismissal":"16.6","bowler_id":"97073","dismissal":"caught","number":5},"extra_runs":{"byes":0,"legbyes":0,"wides":3,"noballs":0,"penalty":"0","total":3},"equations":{"runs":130,"wickets":5,"overs":"17.5","bowlers_used":6,"runrate":"7.29"},"current_partnership":{"runs":10,"balls":5,"overs":0.5,"batsmen":[{"name":"Prayas Ray Barman","batsman_id":94087,"runs":9,"balls":4},{"name":"Badal Singh-Balyan","batsman_id":140355,"runs":1,"balls":1}]},"did_not_bat":[{"player_id":"108858","name":"Priyank Patel"},{"player_id":"681","name":"Manoj Tiwary"},{"player_id":"149800","name":"Pradeep Kumar"},{"player_id":"97072","name":"Geet Puri"},{"player_id":"48568","name":"Kaushik Maity"}],"max_over":"18","target":"128","recent_scores":"4,1,1,0,4,w,1,w,1,2,6,1,0,0,2,1,1,1","last_five_overs":"48\/2 9.29","last_ten_overs":"78\/3 7.55"},"teams":[{"tid":128511,"title":"Harbour Diamonds","abbr":"HD","alt_name":"Harbour Diamonds","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"130\/5 (17.5 ov)","scores":"130\/5","overs":"17.5"},{"tid":128513,"title":"Rashmi Medinipur Wizards","abbr":"RMW","alt_name":"Rashmi Medinipur Wizards","type":"club","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","country":"in","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/9 (18 ov)","scores":"127\/9","overs":"18"}],"players":[{"pid":681,"title":"Manoj Tiwary","short_name":"M Tiwary","first_name":"Manoj Tiwary","last_name":"","middle_name":"","birthdate":"1985-11-14","birthplace":"Howrah, Bengal","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"https:\/\/www.facebook.com\/ManojTiwaryOfficial","twitter_profile":"https:\/\/twitter.com\/tiwarymanoj","instagram_profile":"https:\/\/www.instagram.com\/mannirocks14\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":48568,"title":"Kaushik Maity","short_name":"Kaushik Maity","first_name":"Kaushik Maity","last_name":"","middle_name":"","birthdate":"1999-10-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":53501,"title":"Sudip Chatterjee","short_name":"SD Chatterjee","first_name":"Sudip Chatterjee","last_name":"","middle_name":"","birthdate":"1991-11-11","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/sudipchatterjee06\/?hl=en","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":"(C)"},{"pid":54418,"title":"Abhimanyu Easwaran","short_name":"A Easwaran","first_name":"Abhimanyu Easwaran","last_name":"","middle_name":"","birthdate":"1995-09-06","birthplace":" Dehradun","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"https:\/\/www.facebook.com\/Abhimanyueaswaranofficial\/","twitter_profile":"https:\/\/twitter.com\/AbhimanyuEaswa1","instagram_profile":"https:\/\/www.instagram.com\/easwaranabhimanyu1\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":54537,"title":"Sandipan Das","short_name":"S Das","first_name":"Sandipan Das","last_name":"","middle_name":"","birthdate":"1992-11-29","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":55706,"title":"Vivek Singh","short_name":"V Singh","first_name":"Vivek Singh","last_name":"","middle_name":"","birthdate":"1993-11-01","birthplace":"Howrah","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":55769,"title":"Ritwik Roy Chowdhury","short_name":"R Chowdhury","first_name":"Ritwik Roy Chowdhury","last_name":"","middle_name":"","birthdate":"1995-11-20","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":90396,"title":"Pankaj Shaw","short_name":"PP Shaw","first_name":"Pankaj Shaw","last_name":"","middle_name":"","birthdate":"1988-02-12","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":90520,"title":"Abhishek Raman","short_name":"A Raman","first_name":"Abhishek Raman","last_name":"","middle_name":"","birthdate":"1993-09-06","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":94087,"title":"Prayas Ray Barman","short_name":"P Ray Barman","first_name":"Prayas Ray Barman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":97072,"title":"Geet Puri","short_name":"G Puri","first_name":"Geet Puri","last_name":"","middle_name":"","birthdate":"1994-11-06","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":97073,"title":"Raj Kumar Pal","short_name":"RK Pal","first_name":"Raj Kumar Pal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":103183,"title":"Rahul Prasad","short_name":"R Prasad","first_name":"Rahul Prasad","last_name":"","middle_name":"","birthdate":"2004-10-13","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":104502,"title":"Subham Sarkar","short_name":"S Sarkar","first_name":"Subham Sarkar","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":104506,"title":"Prakash KR Roy","short_name":"P KR Roy","first_name":"Prakash KR Roy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":104530,"title":"Dipanjan Mukherjee","short_name":"D Mukherjee","first_name":"Dipanjan Mukherjee","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":108858,"title":"Priyank Patel","short_name":"P Patel","first_name":"Priyank Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":"(WK)"},{"pid":110055,"title":"Vaibhav Yadav","short_name":"V Yadav","first_name":"Vaibhav Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":111826,"title":"Ranjot Singh Khaira","short_name":"Ranjot Singh Khaira","first_name":"Ranjot Singh Khaira","last_name":"","middle_name":"","birthdate":"1998-10-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":112723,"title":"Aishik Patel","short_name":"A Patel","first_name":"Aishik Patel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112739,"title":"Kaushik Giri","short_name":"K Giri","first_name":"Kaushik Giri","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":112765,"title":"Rahul Kundu","short_name":"R Kundu","first_name":"Rahul Kundu","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":120530,"title":"Chandrahas Dash","short_name":"C Dash","first_name":"Chandrahas Dash","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":120630,"title":"Akash Ghatak","short_name":"A Ghatak","first_name":"Akash Ghatak","last_name":"","middle_name":"","birthdate":"1996-10-13","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/akash.ghatak.92\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/akashghatak16\/","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":127126,"title":"Sourav Halder","short_name":"S Halder","first_name":"Sourav Halder","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":140341,"title":"Rahul Gupta","short_name":"R Gupta","first_name":"Rahul Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140344,"title":"Vishal Bhati","short_name":"V Bhati","first_name":"Vishal Bhati","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140355,"title":"Badal Singh-Balyan","short_name":"BS-Balyan","first_name":"Badal Singh-Balyan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"wk","role_str":""},{"pid":140360,"title":"Balkesh Yadav","short_name":"B Yadav","first_name":"Balkesh Yadav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":140370,"title":"Priyanshu Gaurav Srivastav","short_name":"PG Srivastav","first_name":"Priyanshu Gaurav Srivastav","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bat","role_str":""},{"pid":140372,"title":"Ayush Ghosh","short_name":"A Ghosh","first_name":"Ayush Ghosh","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":146312,"title":"Soumyadip Mandal","short_name":"S Mandal","first_name":"Soumyadip Mandal","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"bowl","role_str":""},{"pid":149698,"title":"Jagmohan Prasad Gupta","short_name":"J Prasad Gupta","first_name":"Jagmohan Prasad Gupta","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""},{"pid":149800,"title":"Pradeep Kumar","short_name":"P Kumar","first_name":"Pradeep Kumar","last_name":"","middle_name":"","birthdate":"2001-07-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"all","role_str":""},{"pid":149801,"title":"Vijay Srivastava","short_name":"V Srivastava","first_name":"Vijay Srivastava","last_name":"","middle_name":"","birthdate":"2007-10-25","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"India","role":"squad","role_str":""}]},"etag":"d40bce2eb84e293e7851b81ea4a1cea4","modified":"2025-06-27 03:08:26","datetime":"2025-06-27 03:08:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90572 AND DataTypeId = 1 END
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'.
Invalid column name 'ErrorLog'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117
ClientConnectionId:1792bf5d-8253-4af2-bb62-9beeb89df983
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90572 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90572,3,'{"status":"ok","response":{"match_id":90572,"title":"Rashmi Medinipur Wizards vs Harbour Diamonds","short_title":"RMW vs HD","subtitle":"Match 17","match_number":"17","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Harbour Diamonds won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129619,"title":"Bengal Pro T20 League","abbr":"Bengal Pro T20 League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-11","dateend":"2025-06-28","country":"in","total_matches":"31","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128513,"name":"Rashmi Medinipur Wizards","short_name":"RMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","scores_full":"127\/9 (18 ov)","scores":"127\/9","overs":"18"},"teamb":{"team_id":128511,"name":"Harbour Diamonds","short_name":"HD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","scores_full":"130\/5 (17.5 ov)","scores":"130\/5","overs":"17.5"},"date_start":"2025-06-19 13:30:00","date_end":"2025-06-19 23:30:00","timestamp_start":1750339800,"timestamp_end":1750375800,"date_start_ist":"2025-06-19 19:00:00","date_end_ist":"2025-06-20 05:00:00","venue":{"venue_id":"18","name":"Eden Gardens","location":"Kolkata","country":"India","timezone":""},"umpires":"Premdip Chatterjee (India), Manoj Shaw (India), Krishendu Pal (India, TV)","referee":"Rajeev S (India)","equation":"","live":"","result":"HD won by 5 wickets","result_type":2,"win_margin":"5 wickets","winning_team_id":128511,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 20:12:43","verify_time":"2025-06-19 23:51:30","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.85,"humidity":82,"visibility":10000,"wind_speed":"10.65","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Harbour Diamonds elected to bowl","winner":128511,"decision":2}},"etag":"d40bce2eb84e293e7851b81ea4a1cea4","modified":"2025-06-27 03:08:26","datetime":"2025-06-27 03:08:26","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90572,"title":"Rashmi Medinipur Wizards vs Harbour Diamonds","short_title":"RMW vs HD","subtitle":"Match 17","match_number":"17","format":6,"format_str":"T20","status":2,"status_str":"Completed","status_note":"Harbour Diamonds won by 5 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129619,"title":"Bengal Pro T20 League","abbr":"Bengal Pro T20 League","type":"tournament","category":"domestic","match_format":"t20","season":"2025","status":"live","datestart":"2025-06-11","dateend":"2025-06-28","country":"in","total_matches":"31","total_rounds":"1","total_teams":"8"},"teama":{"team_id":128513,"name":"Rashmi Medinipur Wizards","short_name":"RMW","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/rmw.png","scores_full":"127\/9 (18 ov)","scores":"127\/9","overs":"18"},"teamb":{"team_id":128511,"name":"Harbour Diamonds","short_name":"HD","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2024\/06\/hd.png","scores_full":"130\/5 (17.5 ov)","scores":"130\/5","overs":"17.5"},"date_start":"2025-06-19 13:30:00","date_end":"2025-06-19 23:30:00","timestamp_start":1750339800,"timestamp_end":1750375800,"date_start_ist":"2025-06-19 19:00:00","date_end_ist":"2025-06-20 05:00:00","venue":{"venue_id":"18","name":"Eden Gardens","location":"Kolkata","country":"India","timezone":""},"umpires":"Premdip Chatterjee (India), Manoj Shaw (India), Krishendu Pal (India, TV)","referee":"Rajeev S (India)","equation":"","live":"","result":"HD won by 5 wickets","result_type":2,"win_margin":"5 wickets","winning_team_id":128511,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-06-17 20:12:43","verify_time":"2025-06-19 23:51:30","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Clouds","weather_desc":"overcast clouds","temp":26.85,"humidity":82,"visibility":10000,"wind_speed":"10.65","clouds":100},"pitch":{"pitch_condition":"Flat Track Pitch","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Harbour Diamonds elected to bowl","winner":128511,"decision":2}},"etag":"d40bce2eb84e293e7851b81ea4a1cea4","modified":"2025-06-27 03:08:26","datetime":"2025-06-27 03:08:26","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90572 AND DataTypeId = 3 END Live Report & Scorecard of Rashmi Medinipur Wizards vs Harbour Diamonds Match 17
Rashmi Medinipur Wizards vs Harbour Diamonds, Live Cricket Commentary