Visual LANSA Forum

Thank you for the responses - I have resolved the issue by moving the response to NVARCHAR string field, then extracting the name and value pairs into an array thus :

Def_List Name(#List_Stock_Levels) Fields(#product_id #quantity) Counter(#LISTCOUNT) Type(*WORKING) Entrys(*MAX)
Define Field ...

The API returns a JSON object with product IDs as keys and their respective quantities as values? i.e keyed pair value.
i.e. { "product_id_1": "quantity_1", "product_id_2": "quantity_2", "product_id_3": "quantity_3"}

The following code only returns the quantity, and not the product IDs..

For Each ...

RESOLVED :) - had to use the FileStreamWriter to decode base64 value to PDF in my case i.e.

#ToDocumentPath := '/SOP/'
#ToDocumentPath := #ToDocumentPath.Trim + #TBINVP + #SHIPMENTID.AsDisplayString( NumString_L ) + '.' + #iOperationRequest.ContentJsonIn.PackingSlipFormat
#ToDocumentPathSave ...

We have a server module ( JSON restful call ) to accept shipment data which includes PDF packing slip encoded in Base64String. We have no issues with PDFs which are less than 64Kb but where PDFs are greater than 64Kb, the statement high-lighted in bold/red fails:

We have verified that ...

Integrator SMB appears to be the ideal solution - What are the steps involved in setting up and using SMB service? Do you need to install any third party software or is it all part of Integrator?

Thanks for your help.

The penny has dropped!

I believe I was over-complicating the issue - The bind service to read HTTP request content with the BLOB field receiving the 64bit encoded field element creates a object file with a .BIN extension. By reading the BLOB field will give you a path to the ...

LANSA Integrator - How do you decode a base64 string and turn it into a file (as pdf) and save it to a network drive using a function?

I am working on a project using Royal Mail API Shipping V2 REST APIs.
One of the APIs sends a JSON response back containing an entity which is in BASE64 encoded ...