+16I am working on an App and I want to incorporate the economic activities.. these are available via public API. (https://servicodados.ibge.gov.br/api/v2/cnae/subclasses)
How do I process this? Because I know use a NVARCHAR(MAX) variable, but I don't think it can hold the whole result? 37.8 MB ..
However it does process but only a part of all the economic activities. Is there a way to save the JSON as a file and later on process it?
Best answer by Mark Jongeling
Hi Freddy,
Nvarchar(max) is able to hold 2,1GB of data so that shouldn't be the problem.
The content returned by this API is the JSON which you can capture inside a process variable with nvarchar(max). In a process procedure you can then query the data in SQL using openjson() for example.
Alternatively, you may also write that JSON to a file using the Write file connector for later processing; depends on the Use case.
+23Hi Freddy,
Nvarchar(max) is able to hold 2,1GB of data so that shouldn't be the problem.
The content returned by this API is the JSON which you can capture inside a process variable with nvarchar(max). In a process procedure you can then query the data in SQL using openjson() for example.
Alternatively, you may also write that JSON to a file using the Write file connector for later processing; depends on the Use case.
+16I’ll have to troubleshoot, because I see more data in the DB but it only shows so many records and there is no cap defined in the settings.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.