NVARCHAR(MAX) can hold up to 2 GB of data, so a 700 KB JSON string is not a problem by itself.
NVARCHAR(MAX)
JSON
However, building and storing large JSON blobs inside SQL Server is not recommended.
SQL Server
Maximum capacity specifications for SQL Server