Limitation in answer of API call

Request description

Hello, we are currently facing an issue where we have an answer to an API through a POST call on Simplicité and we are encountering a limitation of 1 million characters. Is there any limitation on Simplicité side and if so is it possible to increase the maximum characters limit or should we look on our side ?

Thank you in advance.

Thomas

Hello,

What is the error you get? Do you have an extract of the request and the response? What does the code look like? What version of Simplicité are you using?..

We are using Simplicité version 5.3.40.
We do not get an error per say, the result is just cut to 1 million characters. The request is : POST https://apis.renault.com/enterprise-repositories-alliance-suppliers/v1/bvd-interface
And the response (abbreviated here) is :

{

  "result": "{\"SearchSummary\":{\"TotalRecordsFound\":1,\"Offset\":0,\"RecordsReturned\":1,\"DatabaseInfo\":{\"ReleaseNumber\":\"351\",\"UpdateNumber\":\"351001\",\"UpdateDate\":\"2024-08-02T00:00:00\",\"VersionNumber\":\"129.00\",\"IndexationDate\":\"2024-07-29T00:00:00\"},\"Sort\":null},\"Data\":[{\"NAME\":\"LA POSTE\",\"LEGAL_ACCOUNT_INFORMATION\":{\"STATUS\":[\"Active\"]},\"BVD_ID_NUMBER\":\"FR356000000\",\"ADDRESS_LINE1\":\"DIRECTION GENERALE DE LA POSTE\",\"ADDRESS_LINE2\":\"9 RUE DU COLONEL PIERRE AVIA\",\"ADDRESS_LINE3\":null,\"POSTCODE\":\"75015\",\"CITY\":\"PARIS\",\"COUNTRY_REGION\":[\"Ile-de-France\",\"Paris\"],\"COUNTRY_ISO_CODE\":\"FR\",\"COUNTRY\":\"France\",\"LATITUDE\":48.8307237371554,\"LONGITUDE\":2.27682378248516,\"NATIONAL_ID\":[\"356000000\",\"356000000-00048\",\"FR39 356000000\",\"9695000YG7TR7PAP0L59\",\"356000000\",\"FR39 356000000\"],\"NATIONAL_ID_LABEL\":[\"SIREN number\",\"SIRET number\",\"European VAT number\",\"LEI\",\"TIN\",\"VAT number\"],\"VAT_NUMBER\":[\"FR39 356000000\"],\"EUROPEAN_VAT_NUMBER\":\"FR39 356000000\",\"BRANCH_INDICATOR\":false,\"BRANCH_NAME\":[\"LA POSTE\",\"LA POSTE\",\"LA POSTE\",\"LA POSTE\",\"LA POSTE\",\"LA POSTE\",\"LA POSTE\",(…),\"MONCEAUX SUR DORDOGNE\",\"NEUVIC\",\"NONARDS\",\"OBJAT\",\"PERPEZAC LE BLANC\",\"PEYRELEVADE\",\"ST ANGEL\",\"ST AULAIRE\",\"ST CHAMANT\",\"STE FORTUNADE\",\"ST MA",

  "national-id": "",

  "country": "",

  "address": "",

  "city": "",

  "name": "",

  "row_id": "35",

  "bvd-id": "FR356000000"

}

Can you please provide the code used to make the request so I can check wether the limitation could be coming from one of our tools, one of the underlying libraries, the tomcat server, etc.

At a lower level, how have you made sure the responsibility effectively falls on the app rather than the proxy of some other network component (for example by successfully executing the request with curl from the docker image that I understand you’re using)?

I might have misunderstood that you were asking about a call FROM a Simplicité instance, but you’re talking about an API call TO a Simplicité instance, right? In that case, I don’t need the code.

Just to make sure I understand right:

  • some app calls POST a Mapped REST service (/enterprise-repositories-alliance-suppliers/v1/bvd-interface of a Simplicité instance)
  • this instance must
    • store the content you send in the database
    • answer with the created record
  • the cut result you mention is what you see in the result field?
  • could the limit be the column size in the DB, or is the data OK there?

As far as we know, there is no set limit. If there is a problem, like an OutOfMemoryException, you should see something in the Simplicité logs.

Could you provide additional information so I can try to reproduce your case?

Hello,

The problem was indeed on our side and is now resolved. The column size in the DB was set to 1 million characters.

Thank you for your support.

Thomas

[Predefined Message]

In order for our support team to bring you a better service, and for the rest of the community to find the significant answers more easily, we kindly ask our user to mark as “solved” once a solution has been found.

Your messages indicating that the issue was fixed, we’ve realized this action on your behalf.