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:52d9c991-d1ea-414e-96e8-eae8e0dcfcd2
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91210 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91210,1,'{"status":"ok","response":{"mid":91210,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Italy won by 7 wickets","day_remaining_over":"","team_batting":"Italy","team_bowling":"Guernsey","live_inning_number":2,"live_score":{"runs":127,"overs":14,"wickets":3,"target":123,"runrate":9.07,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Manenti","batsman_id":62053,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Justin Mosca","batsman_id":117956,"runs":66,"balls_faced":37,"fours":6,"sixes":3,"strike_rate":"178.38"}],"bowlers":[{"name":"Martin Dale Bradley","bowler_id":129015,"overs":3,"runs_conceded":24,"wickets":1,"maidens":0,"econ":"8.00"},{"name":"Charlie Forshaw","bowler_id":129994,"overs":3,"runs_conceded":31,"wickets":0,"maidens":0,"econ":"10.33"}],"commentaries":[{"event_id":"12289185","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"9","ball":"5","score":1,"commentary":"Martin Dale Bradley to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751732744,"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":"12289188","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"9","ball":"6","score":4,"commentary":"Martin Dale Bradley to Harry J Manenti, Four,","noball_dismissal":false,"text":"","timestamp":1751732987,"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":"overend","over":10,"runs":8,"score":"90\/2","bats":[{"runs":10,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":99800},{"runs":42,"balls_faced":27,"fours":6,"sixes":1,"batsman_id":117956}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":129015,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":129999,"overs":2}],"commentary":"End of over 10 (8 runs), Italy 90\/2"},{"event_id":"12289218","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"1","score":1,"commentary":"Anthony Stokes to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733022,"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":"12289227","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"2","score":0,"commentary":"Anthony Stokes to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733030,"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":"12289228","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"3","score":0,"commentary":"Anthony Stokes to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733053,"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":"12289230","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"4","score":1,"commentary":"Anthony Stokes to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733055,"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":"12289235","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"5","score":6,"commentary":"Anthony Stokes to Justin Mosca, Six,","noball_dismissal":false,"text":"","timestamp":1751733088,"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":"12289239","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"6","score":2,"commentary":"Anthony Stokes to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733150,"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":"overend","over":11,"runs":10,"score":"100\/2","bats":[{"runs":51,"balls_faced":30,"fours":6,"sixes":2,"batsman_id":117956},{"runs":11,"balls_faced":12,"fours":1,"sixes":0,"batsman_id":99800}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":95331,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":129015,"overs":2}],"commentary":"End of over 11 (10 runs), Italy 100\/2"},{"event_id":"12289247","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"1","score":1,"commentary":"Adam Martel to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733160,"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":"12289254","event":"ball","batsman_id":"117956","bowler_id":"84988","over":"11","ball":"2","score":1,"commentary":"Adam Martel to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733177,"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":"12289258","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"3","score":0,"commentary":"Adam Martel to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733202,"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":"12289263","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"4","score":2,"commentary":"Adam Martel to Harry J Manenti, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733226,"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":"12289265","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"5","score":0,"commentary":"Adam Martel to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733253,"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":"12289267","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"6","score":2,"commentary":"Adam Martel to Harry J Manenti, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733342,"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":"overend","over":12,"runs":6,"score":"106\/2","bats":[{"runs":16,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":99800},{"runs":52,"balls_faced":31,"fours":6,"sixes":2,"batsman_id":117956}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":84988,"overs":2},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":95331,"overs":2}],"commentary":"End of over 12 (6 runs), Italy 106\/2"},{"event_id":"12289274","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"1","score":1,"commentary":"Charlie Forshaw to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733367,"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":"12289277","event":"ball","batsman_id":"99800","bowler_id":"129994","over":"12","ball":"2","score":1,"commentary":"Charlie Forshaw to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733392,"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":"12289279","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"3","score":1,"commentary":"Charlie Forshaw to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733396,"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":"12289281","event":"ball","batsman_id":"99800","bowler_id":"129994","over":"12","ball":"4","score":1,"commentary":"Charlie Forshaw to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733466,"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":"12289282","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"5","score":2,"commentary":"Charlie Forshaw to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733469,"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":"12289286","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"6","score":2,"commentary":"Charlie Forshaw to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733499,"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":"overend","over":13,"runs":8,"score":"114\/2","bats":[{"runs":58,"balls_faced":35,"fours":6,"sixes":2,"batsman_id":117956},{"runs":18,"balls_faced":19,"fours":1,"sixes":0,"batsman_id":99800}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":129994,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":84988,"overs":2}],"commentary":"End of over 13 (8 runs), Italy 114\/2"},{"event_id":"12289297","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"1","score":4,"commentary":"Martin Dale Bradley to Harry J Manenti, Four,","noball_dismissal":false,"text":"","timestamp":1751733581,"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":"12289310","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"2","score":0,"commentary":"Martin Dale Bradley to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733655,"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":"12289312","event":"wicket","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"3","score":"w","commentary":"Martin Dale Bradley to Harry J Manenti, no run, c ACF Stokes b M Bradley,","noball_dismissal":false,"text":"","timestamp":1751733717,"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":"99800","how_out":"c ACF Stokes b M Bradley","batsman_runs":"22","batsman_balls":"22"},{"event_id":"12289326","event":"ball","batsman_id":"62053","bowler_id":"129015","over":"13","ball":"4","score":1,"commentary":"Martin Dale Bradley to Ben Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733733,"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":"12289331","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"13","ball":"5","score":2,"commentary":"Martin Dale Bradley to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733801,"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":"12289334","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"13","ball":"6","score":6,"commentary":"Martin Dale Bradley to Justin Mosca, Six,","noball_dismissal":false,"text":"","timestamp":1751733804,"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":14,"runs":13,"score":"127\/3","bats":[{"runs":66,"balls_faced":37,"fours":6,"sixes":3,"batsman_id":117956},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":62053}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":129015,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":129994,"overs":3}],"commentary":"End of over 14 (13 runs), Italy 127\/3"}],"day":"0","session":"0","live_inning":{"iid":199159,"number":2,"name":"Italy Inning","short_name":"ITA Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19818,"fielding_team_id":10528,"scores":"127\/3","scores_full":"127\/3 (14 ov)","fielder":[{"fielder_id":"95871","fielder_name":"Ben Fitchet","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"52461","fielder_name":"Tom Nightingale","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95331","fielder_name":"Anthony Stokes","catches":1,"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":"Harry J Manenti","batsman_id":"99800","runs":"22","balls":"22","how_out":"c ACF Stokes b M Bradley","score_at_dismissal":118,"overs_at_dismissal":"13.3","bowler_id":"129015","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":127,"wickets":3,"overs":"14","bowlers_used":6,"runrate":"9.07"},"current_partnership":{"runs":9,"balls":3,"overs":0.3,"batsmen":[{"name":"Ben Manenti","batsman_id":62053,"runs":1,"balls":1},{"name":"Justin Mosca","batsman_id":117956,"runs":8,"balls":2}]},"did_not_bat":[{"player_id":"117226","name":"Marcus Campopiano"},{"player_id":"117955","name":"Anthony Joseph Mosca"},{"player_id":"92940","name":"Grant Stewart"},{"player_id":"102581","name":"Crishan Kalugamage"},{"player_id":"95025","name":"Jaspreet Singh"},{"player_id":"140330","name":"Thomas Jack Draca"}],"max_over":"20","target":"123","recent_scores":"6,2,1,w,0,4,2,2,1,1,1,1,2,0,2,0,1,1","last_five_overs":"45\/1 9.00","last_ten_overs":"92\/2 9.20"},"teams":[{"tid":10528,"title":"Guernsey","abbr":"GUE","alt_name":"Guernsey","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","country":"gg","sex":"male","team_owner":"","head_coach":"","scores_full":"122\/9 (20 ov)","scores":"122\/9","overs":"20"},{"tid":19818,"title":"Italy","abbr":"ITA","alt_name":"Italy","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","country":"it","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/3 (14 ov)","scores":"127\/3","overs":"14"}],"players":[{"pid":43506,"title":"Joe Burns","short_name":"Joe Burns","first_name":"Joe Burns","last_name":"","middle_name":"","birthdate":"1989-09-06","birthplace":"","country":"au","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/joeburns441\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joeburns441\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":"(C)"},{"pid":50839,"title":"Matthew Stokes","short_name":"MWR Stokes","first_name":"Matthew Stokes","last_name":"","middle_name":"","birthdate":"1995-10-07","birthplace":"","country":"","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":""},{"pid":52461,"title":"Tom Nightingale","short_name":"T Nightingale","first_name":"Tom Nightingale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"bat","role_str":""},{"pid":57557,"title":"Gian Meade","short_name":"G Meade","first_name":"Gian Meade","last_name":"","middle_name":"","birthdate":"1996-03-19","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":62053,"title":"Ben Manenti","short_name":"BAD Manenti","first_name":"Ben Manenti","last_name":"","middle_name":"","birthdate":"1997-03-23","birthplace":" Alexandria, Sydney, New South Wales","country":"it","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benmanenti\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":84988,"title":"Adam Martel","short_name":"A Martel","first_name":"Adam Martel","last_name":"","middle_name":"","birthdate":"1991-09-23","birthplace":"","country":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":""},{"pid":92940,"title":"Grant Stewart","short_name":"G Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"1994-02-19","birthplace":"Kalgoorlie, Western Australia","country":"it","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gstewart195\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":95025,"title":"Jaspreet Singh","short_name":"Jaspreet Singh","first_name":"Jaspreet Singh","last_name":"","middle_name":"","birthdate":"1993-06-09","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":95331,"title":"Anthony Stokes","short_name":"ACF Stokes","first_name":"Anthony Stokes","last_name":"","middle_name":"","birthdate":"1998-11-01","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"bowl","role_str":""},{"pid":95871,"title":"Ben Fitchet","short_name":"B Fitchet","first_name":"Ben Fitchet","last_name":"","middle_name":"","birthdate":"1992-11-08","birthplace":"","country":"gg","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bat","role_str":""},{"pid":96106,"title":"Emilio Gay","short_name":"E Gay","first_name":"Emilio Gay","last_name":"","middle_name":"","birthdate":"2000-04-14","birthplace":"Bedford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":98736,"title":"Nathan Le Tissier","short_name":"NL Tissier","first_name":"Nathan Le Tissier","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":98737,"title":"Luke Bichard","short_name":"L Bichard","first_name":"Luke Bichard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":99137,"title":"Bilal Khan","short_name":"B Khan","first_name":"Bilal Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"squad","role_str":""},{"pid":99800,"title":"Harry J Manenti","short_name":"H Manenti","first_name":"Harry J Manenti","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":102581,"title":"Crishan Kalugamage","short_name":"C Kalugamage","first_name":"Crishan Kalugamage","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":106934,"title":"Damith Kosala","short_name":"D Kosala","first_name":"Damith Kosala","last_name":"","middle_name":"","birthdate":"2001-11-01","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":107208,"title":"Zain Naqvi","short_name":"Z Naqvi","first_name":"Zain Naqvi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":117226,"title":"Marcus Campopiano","short_name":"M Campopiano","first_name":"Marcus Campopiano","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"wk","role_str":"(WK)"},{"pid":117799,"title":"Zain Ali","short_name":"Z Ali","first_name":"Zain Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":117955,"title":"Anthony Joseph Mosca","short_name":"A J Mosca","first_name":"Anthony Joseph Mosca","last_name":"","middle_name":"","birthdate":"1991-08-21","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bat","role_str":""},{"pid":117956,"title":"Justin Mosca","short_name":"J Mosca","first_name":"Justin Mosca","last_name":"","middle_name":"","birthdate":"1994-11-15","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bat","role_str":""},{"pid":124312,"title":"Ollie Nightingale","short_name":"O Nightingale","first_name":"Ollie Nightingale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bat","role_str":"(C)"},{"pid":129015,"title":"Martin Dale Bradley","short_name":"M Bradley","first_name":"Martin Dale Bradley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":129994,"title":"Charlie Forshaw","short_name":"C Forshaw","first_name":"Charlie Forshaw","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":129995,"title":"Charlie Birch","short_name":"C Birch","first_name":"Charlie Birch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":129997,"title":"Oliver Clapham","short_name":"O Clapham","first_name":"Oliver Clapham","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":129999,"title":"Harry Johnson","short_name":"H Johnson","first_name":"Harry Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":130301,"title":"Alexander Bushell","short_name":"Alexander Bushell","first_name":"Alexander Bushell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":132635,"title":"Joshua Butler","short_name":"J Butler","first_name":"Joshua Butler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":140330,"title":"Thomas Jack Draca","short_name":"T Jack Draca","first_name":"Thomas Jack Draca","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":141798,"title":"Dec Martel","short_name":"D Martel","first_name":"Dec Martel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":141799,"title":"Lee Benjamin Ferbrache","short_name":"L Benjamin Ferbrache","first_name":"Lee Benjamin Ferbrache","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":147434,"title":"Zak Damarell","short_name":"Z Damarell","first_name":"Zak Damarell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"wk","role_str":"(WK)"},{"pid":150320,"title":"Edward Robinson","short_name":"E Robinson","first_name":"Edward Robinson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""}]},"etag":"bffc2062ddc548d4b2ca237efd5cd106","modified":"2025-07-26 20:36:27","datetime":"2025-07-26 20:36:27","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":91210,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Italy won by 7 wickets","day_remaining_over":"","team_batting":"Italy","team_bowling":"Guernsey","live_inning_number":2,"live_score":{"runs":127,"overs":14,"wickets":3,"target":123,"runrate":9.07,"required_runrate":""},"commentary":1,"wagon":2,"batsmen":[{"name":"Ben Manenti","batsman_id":62053,"runs":1,"balls_faced":1,"fours":0,"sixes":0,"strike_rate":"100.00"},{"name":"Justin Mosca","batsman_id":117956,"runs":66,"balls_faced":37,"fours":6,"sixes":3,"strike_rate":"178.38"}],"bowlers":[{"name":"Martin Dale Bradley","bowler_id":129015,"overs":3,"runs_conceded":24,"wickets":1,"maidens":0,"econ":"8.00"},{"name":"Charlie Forshaw","bowler_id":129994,"overs":3,"runs_conceded":31,"wickets":0,"maidens":0,"econ":"10.33"}],"commentaries":[{"event_id":"12289185","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"9","ball":"5","score":1,"commentary":"Martin Dale Bradley to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751732744,"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":"12289188","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"9","ball":"6","score":4,"commentary":"Martin Dale Bradley to Harry J Manenti, Four,","noball_dismissal":false,"text":"","timestamp":1751732987,"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":"overend","over":10,"runs":8,"score":"90\/2","bats":[{"runs":10,"balls_faced":9,"fours":1,"sixes":0,"batsman_id":99800},{"runs":42,"balls_faced":27,"fours":6,"sixes":1,"batsman_id":117956}],"bowls":[{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":129015,"overs":2},{"runs_conceded":18,"maidens":0,"wickets":1,"bowler_id":129999,"overs":2}],"commentary":"End of over 10 (8 runs), Italy 90\/2"},{"event_id":"12289218","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"1","score":1,"commentary":"Anthony Stokes to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733022,"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":"12289227","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"2","score":0,"commentary":"Anthony Stokes to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733030,"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":"12289228","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"3","score":0,"commentary":"Anthony Stokes to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733053,"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":"12289230","event":"ball","batsman_id":"99800","bowler_id":"95331","over":"10","ball":"4","score":1,"commentary":"Anthony Stokes to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733055,"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":"12289235","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"5","score":6,"commentary":"Anthony Stokes to Justin Mosca, Six,","noball_dismissal":false,"text":"","timestamp":1751733088,"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":"12289239","event":"ball","batsman_id":"117956","bowler_id":"95331","over":"10","ball":"6","score":2,"commentary":"Anthony Stokes to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733150,"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":"overend","over":11,"runs":10,"score":"100\/2","bats":[{"runs":51,"balls_faced":30,"fours":6,"sixes":2,"batsman_id":117956},{"runs":11,"balls_faced":12,"fours":1,"sixes":0,"batsman_id":99800}],"bowls":[{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":95331,"overs":2},{"runs_conceded":11,"maidens":0,"wickets":0,"bowler_id":129015,"overs":2}],"commentary":"End of over 11 (10 runs), Italy 100\/2"},{"event_id":"12289247","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"1","score":1,"commentary":"Adam Martel to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733160,"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":"12289254","event":"ball","batsman_id":"117956","bowler_id":"84988","over":"11","ball":"2","score":1,"commentary":"Adam Martel to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733177,"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":"12289258","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"3","score":0,"commentary":"Adam Martel to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733202,"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":"12289263","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"4","score":2,"commentary":"Adam Martel to Harry J Manenti, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733226,"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":"12289265","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"5","score":0,"commentary":"Adam Martel to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733253,"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":"12289267","event":"ball","batsman_id":"99800","bowler_id":"84988","over":"11","ball":"6","score":2,"commentary":"Adam Martel to Harry J Manenti, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733342,"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":"overend","over":12,"runs":6,"score":"106\/2","bats":[{"runs":16,"balls_faced":17,"fours":1,"sixes":0,"batsman_id":99800},{"runs":52,"balls_faced":31,"fours":6,"sixes":2,"batsman_id":117956}],"bowls":[{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":84988,"overs":2},{"runs_conceded":13,"maidens":0,"wickets":0,"bowler_id":95331,"overs":2}],"commentary":"End of over 12 (6 runs), Italy 106\/2"},{"event_id":"12289274","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"1","score":1,"commentary":"Charlie Forshaw to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733367,"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":"12289277","event":"ball","batsman_id":"99800","bowler_id":"129994","over":"12","ball":"2","score":1,"commentary":"Charlie Forshaw to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733392,"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":"12289279","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"3","score":1,"commentary":"Charlie Forshaw to Justin Mosca, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733396,"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":"12289281","event":"ball","batsman_id":"99800","bowler_id":"129994","over":"12","ball":"4","score":1,"commentary":"Charlie Forshaw to Harry J Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733466,"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":"12289282","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"5","score":2,"commentary":"Charlie Forshaw to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733469,"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":"12289286","event":"ball","batsman_id":"117956","bowler_id":"129994","over":"12","ball":"6","score":2,"commentary":"Charlie Forshaw to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733499,"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":"overend","over":13,"runs":8,"score":"114\/2","bats":[{"runs":58,"balls_faced":35,"fours":6,"sixes":2,"batsman_id":117956},{"runs":18,"balls_faced":19,"fours":1,"sixes":0,"batsman_id":99800}],"bowls":[{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":129994,"overs":3},{"runs_conceded":15,"maidens":0,"wickets":0,"bowler_id":84988,"overs":2}],"commentary":"End of over 13 (8 runs), Italy 114\/2"},{"event_id":"12289297","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"1","score":4,"commentary":"Martin Dale Bradley to Harry J Manenti, Four,","noball_dismissal":false,"text":"","timestamp":1751733581,"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":"12289310","event":"ball","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"2","score":0,"commentary":"Martin Dale Bradley to Harry J Manenti, no run,","noball_dismissal":false,"text":"","timestamp":1751733655,"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":"12289312","event":"wicket","batsman_id":"99800","bowler_id":"129015","over":"13","ball":"3","score":"w","commentary":"Martin Dale Bradley to Harry J Manenti, no run, c ACF Stokes b M Bradley,","noball_dismissal":false,"text":"","timestamp":1751733717,"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":"99800","how_out":"c ACF Stokes b M Bradley","batsman_runs":"22","batsman_balls":"22"},{"event_id":"12289326","event":"ball","batsman_id":"62053","bowler_id":"129015","over":"13","ball":"4","score":1,"commentary":"Martin Dale Bradley to Ben Manenti, 1 run,","noball_dismissal":false,"text":"","timestamp":1751733733,"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":"12289331","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"13","ball":"5","score":2,"commentary":"Martin Dale Bradley to Justin Mosca, 2 runs,","noball_dismissal":false,"text":"","timestamp":1751733801,"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":"12289334","event":"ball","batsman_id":"117956","bowler_id":"129015","over":"13","ball":"6","score":6,"commentary":"Martin Dale Bradley to Justin Mosca, Six,","noball_dismissal":false,"text":"","timestamp":1751733804,"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":14,"runs":13,"score":"127\/3","bats":[{"runs":66,"balls_faced":37,"fours":6,"sixes":3,"batsman_id":117956},{"runs":1,"balls_faced":1,"fours":0,"sixes":0,"batsman_id":62053}],"bowls":[{"runs_conceded":24,"maidens":0,"wickets":1,"bowler_id":129015,"overs":3},{"runs_conceded":31,"maidens":0,"wickets":0,"bowler_id":129994,"overs":3}],"commentary":"End of over 14 (13 runs), Italy 127\/3"}],"day":"0","session":"0","live_inning":{"iid":199159,"number":2,"name":"Italy Inning","short_name":"ITA Inning","status":2,"issuperover":"false","result":3,"batting_team_id":19818,"fielding_team_id":10528,"scores":"127\/3","scores_full":"127\/3 (14 ov)","fielder":[{"fielder_id":"95871","fielder_name":"Ben Fitchet","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"52461","fielder_name":"Tom Nightingale","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"95331","fielder_name":"Anthony Stokes","catches":1,"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":"Harry J Manenti","batsman_id":"99800","runs":"22","balls":"22","how_out":"c ACF Stokes b M Bradley","score_at_dismissal":118,"overs_at_dismissal":"13.3","bowler_id":"129015","dismissal":"caught","number":3},"extra_runs":{"byes":0,"legbyes":0,"wides":0,"noballs":0,"penalty":"0","total":0},"equations":{"runs":127,"wickets":3,"overs":"14","bowlers_used":6,"runrate":"9.07"},"current_partnership":{"runs":9,"balls":3,"overs":0.3,"batsmen":[{"name":"Ben Manenti","batsman_id":62053,"runs":1,"balls":1},{"name":"Justin Mosca","batsman_id":117956,"runs":8,"balls":2}]},"did_not_bat":[{"player_id":"117226","name":"Marcus Campopiano"},{"player_id":"117955","name":"Anthony Joseph Mosca"},{"player_id":"92940","name":"Grant Stewart"},{"player_id":"102581","name":"Crishan Kalugamage"},{"player_id":"95025","name":"Jaspreet Singh"},{"player_id":"140330","name":"Thomas Jack Draca"}],"max_over":"20","target":"123","recent_scores":"6,2,1,w,0,4,2,2,1,1,1,1,2,0,2,0,1,1","last_five_overs":"45\/1 9.00","last_ten_overs":"92\/2 9.20"},"teams":[{"tid":10528,"title":"Guernsey","abbr":"GUE","alt_name":"Guernsey","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","country":"gg","sex":"male","team_owner":"","head_coach":"","scores_full":"122\/9 (20 ov)","scores":"122\/9","overs":"20"},{"tid":19818,"title":"Italy","abbr":"ITA","alt_name":"Italy","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","country":"it","sex":"male","team_owner":"","head_coach":"","scores_full":"127\/3 (14 ov)","scores":"127\/3","overs":"14"}],"players":[{"pid":43506,"title":"Joe Burns","short_name":"Joe Burns","first_name":"Joe Burns","last_name":"","middle_name":"","birthdate":"1989-09-06","birthplace":"","country":"au","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":8.5,"facebook_profile":"https:\/\/www.facebook.com\/joeburns441\/","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/joeburns441\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Australia","role":"bat","role_str":"(C)"},{"pid":50839,"title":"Matthew Stokes","short_name":"MWR Stokes","first_name":"Matthew Stokes","last_name":"","middle_name":"","birthdate":"1995-10-07","birthplace":"","country":"","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":""},{"pid":52461,"title":"Tom Nightingale","short_name":"T Nightingale","first_name":"Tom Nightingale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"bat","role_str":""},{"pid":57557,"title":"Gian Meade","short_name":"G Meade","first_name":"Gian Meade","last_name":"","middle_name":"","birthdate":"1996-03-19","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":62053,"title":"Ben Manenti","short_name":"BAD Manenti","first_name":"Ben Manenti","last_name":"","middle_name":"","birthdate":"1997-03-23","birthplace":" Alexandria, Sydney, New South Wales","country":"it","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":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/benmanenti\/","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":84988,"title":"Adam Martel","short_name":"A Martel","first_name":"Adam Martel","last_name":"","middle_name":"","birthdate":"1991-09-23","birthplace":"","country":"","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":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":null,"role":"all","role_str":""},{"pid":92940,"title":"Grant Stewart","short_name":"G Stewart","first_name":"Grant Stewart","last_name":"","middle_name":"","birthdate":"1994-02-19","birthplace":"Kalgoorlie, Western Australia","country":"it","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/gstewart195\/","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"all","role_str":""},{"pid":95025,"title":"Jaspreet Singh","short_name":"Jaspreet Singh","first_name":"Jaspreet Singh","last_name":"","middle_name":"","birthdate":"1993-06-09","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":95331,"title":"Anthony Stokes","short_name":"ACF Stokes","first_name":"Anthony Stokes","last_name":"","middle_name":"","birthdate":"1998-11-01","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"bowl","role_str":""},{"pid":95871,"title":"Ben Fitchet","short_name":"B Fitchet","first_name":"Ben Fitchet","last_name":"","middle_name":"","birthdate":"1992-11-08","birthplace":"","country":"gg","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bat","role_str":""},{"pid":96106,"title":"Emilio Gay","short_name":"E Gay","first_name":"Emilio Gay","last_name":"","middle_name":"","birthdate":"2000-04-14","birthplace":"Bedford","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":98736,"title":"Nathan Le Tissier","short_name":"NL Tissier","first_name":"Nathan Le Tissier","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":98737,"title":"Luke Bichard","short_name":"L Bichard","first_name":"Luke Bichard","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":99137,"title":"Bilal Khan","short_name":"B Khan","first_name":"Bilal Khan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"fi","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Finland","role":"squad","role_str":""},{"pid":99800,"title":"Harry J Manenti","short_name":"H Manenti","first_name":"Harry J Manenti","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"au","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":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Australia","role":"all","role_str":""},{"pid":102581,"title":"Crishan Kalugamage","short_name":"C Kalugamage","first_name":"Crishan Kalugamage","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":106934,"title":"Damith Kosala","short_name":"D Kosala","first_name":"Damith Kosala","last_name":"","middle_name":"","birthdate":"2001-11-01","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":107208,"title":"Zain Naqvi","short_name":"Z Naqvi","first_name":"Zain Naqvi","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":117226,"title":"Marcus Campopiano","short_name":"M Campopiano","first_name":"Marcus Campopiano","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"wk","role_str":"(WK)"},{"pid":117799,"title":"Zain Ali","short_name":"Z Ali","first_name":"Zain Ali","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"squad","role_str":""},{"pid":117955,"title":"Anthony Joseph Mosca","short_name":"A J Mosca","first_name":"Anthony Joseph Mosca","last_name":"","middle_name":"","birthdate":"1991-08-21","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bat","role_str":""},{"pid":117956,"title":"Justin Mosca","short_name":"J Mosca","first_name":"Justin Mosca","last_name":"","middle_name":"","birthdate":"1994-11-15","birthplace":"","country":"it","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bat","role_str":""},{"pid":124312,"title":"Ollie Nightingale","short_name":"O Nightingale","first_name":"Ollie Nightingale","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bat","role_str":"(C)"},{"pid":129015,"title":"Martin Dale Bradley","short_name":"M Bradley","first_name":"Martin Dale Bradley","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":129994,"title":"Charlie Forshaw","short_name":"C Forshaw","first_name":"Charlie Forshaw","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":129995,"title":"Charlie Birch","short_name":"C Birch","first_name":"Charlie Birch","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":129997,"title":"Oliver Clapham","short_name":"O Clapham","first_name":"Oliver Clapham","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":129999,"title":"Harry Johnson","short_name":"H Johnson","first_name":"Harry Johnson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bowl","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"bowl","role_str":""},{"pid":130301,"title":"Alexander Bushell","short_name":"Alexander Bushell","first_name":"Alexander Bushell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"International","role":"squad","role_str":""},{"pid":132635,"title":"Joshua Butler","short_name":"J Butler","first_name":"Joshua Butler","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":null,"role":"squad","role_str":""},{"pid":140330,"title":"Thomas Jack Draca","short_name":"T Jack Draca","first_name":"Thomas Jack Draca","last_name":"","middle_name":"","birthdate":"2000-10-23","birthplace":"","country":"it","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Italy","role":"bowl","role_str":""},{"pid":141798,"title":"Dec Martel","short_name":"D Martel","first_name":"Dec Martel","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":141799,"title":"Lee Benjamin Ferbrache","short_name":"L Benjamin Ferbrache","first_name":"Lee Benjamin Ferbrache","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","primary_team":[],"logo_url":"","playing_role":"bat","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""},{"pid":147434,"title":"Zak Damarell","short_name":"Z Damarell","first_name":"Zak Damarell","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"wk","role_str":"(WK)"},{"pid":150320,"title":"Edward Robinson","short_name":"E Robinson","first_name":"Edward Robinson","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gg","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":"","bowling_type":"","thumb_url":"","profile_image":"","nationality":"Guernsey","role":"squad","role_str":""}]},"etag":"bffc2062ddc548d4b2ca237efd5cd106","modified":"2025-07-26 20:36:27","datetime":"2025-07-26 20:36:27","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91210 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:52d9c991-d1ea-414e-96e8-eae8e0dcfcd2
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 91210 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (91210,3,'{"status":"ok","response":{"match_id":91210,"title":"Guernsey vs Italy","short_title":"GUE vs ITA","subtitle":"Match 2","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Italy won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129660,"title":"ICC Mens T20 World Cup Europe Regional Final","abbr":"ICC Mens T20 World Cup Europe Regional Final","type":"tournament","category":"international","match_format":"t20i","season":"2025","status":"live","datestart":"2025-07-05","dateend":"2025-07-11","country":"int","total_matches":"10","total_rounds":"1","total_teams":"5"},"teama":{"team_id":10528,"name":"Guernsey","short_name":"GUE","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","scores_full":"122\/9 (20 ov)","scores":"122\/9","overs":"20"},"teamb":{"team_id":19818,"name":"Italy","short_name":"ITA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","scores_full":"127\/3 (14 ov)","scores":"127\/3","overs":"14"},"date_start":"2025-07-05 14:00:00","date_end":"2025-07-06 00:00:00","timestamp_start":1751724000,"timestamp_end":1751760000,"date_start_ist":"2025-07-05 19:30:00","date_end_ist":"2025-07-06 05:30:00","venue":{"venue_id":"190","name":"Sportpark Westvliet","location":"The Hague","country":"Netherlands","timezone":""},"umpires":"Aidan Seaver (Ireland), Russell Warren (England), Roly Black (Ireland, TV)","referee":"Denavon Hayles (West Indies)","equation":"","live":"","result":"ITA won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":19818,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 01:04:32","verify_time":"2025-07-05 22:30:14","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"moderate rain","temp":21.16,"humidity":79,"visibility":10000,"wind_speed":"16.35","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Italy elected to bowl","winner":19818,"decision":2}},"etag":"d447e12a5e0dbe015f2ff7771ecca6a3","modified":"2025-07-26 20:36:28","datetime":"2025-07-26 20:36:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":91210,"title":"Guernsey vs Italy","short_title":"GUE vs ITA","subtitle":"Match 2","match_number":"2","format":3,"format_str":"T20I","status":2,"status_str":"Completed","status_note":"Italy won by 7 wickets","verified":"true","pre_squad":"true","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129660,"title":"ICC Mens T20 World Cup Europe Regional Final","abbr":"ICC Mens T20 World Cup Europe Regional Final","type":"tournament","category":"international","match_format":"t20i","season":"2025","status":"live","datestart":"2025-07-05","dateend":"2025-07-11","country":"int","total_matches":"10","total_rounds":"1","total_teams":"5"},"teama":{"team_id":10528,"name":"Guernsey","short_name":"GUE","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/Guernsey.png","scores_full":"122\/9 (20 ov)","scores":"122\/9","overs":"20"},"teamb":{"team_id":19818,"name":"Italy","short_name":"ITA","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/05\/italy.png","scores_full":"127\/3 (14 ov)","scores":"127\/3","overs":"14"},"date_start":"2025-07-05 14:00:00","date_end":"2025-07-06 00:00:00","timestamp_start":1751724000,"timestamp_end":1751760000,"date_start_ist":"2025-07-05 19:30:00","date_end_ist":"2025-07-06 05:30:00","venue":{"venue_id":"190","name":"Sportpark Westvliet","location":"The Hague","country":"Netherlands","timezone":""},"umpires":"Aidan Seaver (Ireland), Russell Warren (England), Roly Black (Ireland, TV)","referee":"Denavon Hayles (West Indies)","equation":"","live":"","result":"ITA won by 7 wickets","result_type":2,"win_margin":"7 wickets","winning_team_id":19818,"commentary":1,"wagon":2,"latest_inning_number":2,"presquad_time":"2025-07-04 01:04:32","verify_time":"2025-07-05 22:30:14","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":{"weather":"Rain","weather_desc":"moderate rain","temp":21.16,"humidity":79,"visibility":10000,"wind_speed":"16.35","clouds":100},"pitch":{"pitch_condition":"Fast & Bounce","batting_condition":"Average","pace_bowling_condition":"Pace & Bounce","spine_bowling_condition":"Average"},"toss":{"text":"Italy elected to bowl","winner":19818,"decision":2}},"etag":"d447e12a5e0dbe015f2ff7771ecca6a3","modified":"2025-07-26 20:36:28","datetime":"2025-07-26 20:36:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 91210 AND DataTypeId = 3 END Live Report & Scorecard of Guernsey vs Italy Match 2