is incremental append sync mode available for local_json destination ?

Hi @Akshay Agarwal, yes this source should support incremental sync. If it's not working please open a troubleshooting post on our forum