I have a program reading data from a JSON response. The data is initially read into temp-tables and after the JSON has been successfully processed I copy the temp-table data to the database. One of the temp-tables sometimes is getting 7,600+ rows of data which causes the copy from temp-table to...
Thank you for the suggestion. Yes the page is created with webspeed. I did have the content type set to
output-content-type("text/html":U).
I went ahead and updated it to
output-content-type("text/html~;charset=utf-8":U).
which did help because the error reported earlier no longer comes...
I have a website that redirects a user to a external host for payment processing. When the user is returned to my website depending on the results of the payment processing I need to redirect the user to a final webpage with POST method so their order can be completed. I call the javascript code...
Thank you for the suggestions. I have implemented change. Vendor does not provide a way to test this specific item so I will not know until code has been deployed .
I have a WebSpeed application that is receiving a POST notification from a vendor that includes an XML document. When the WebSpeed page receives the post the vendor requires a respond back with the word 'OK' as acknowledgement that notification was successfully received. How would I handle such...
I am attempting to process an XML document from a vendor using the LOAD statement as below.
ghDocument:LOAD("FILE":u, "c:\sample.xml", FALSE) NO-ERROR.
However I am getting the following error
X-NODEREF or X-DOCUMENT LOAD got an error: FATAL ERROR: file 'c:\sample.xml', line '1', column '0'...
Quick update. Adding the NO-ERROR worked for now.
The reason I asked about this option is because the vendor I am working sometimes nests the json in a way that READ-JSON is not able to support so I wanted to have the information for those cases. Where I can I always use the READ-JSON.
I will...
I am reading data from a json file into a temp-table provided by an external vendor. Some fields on the json file are not included every time. How do I check if a field exists on the json file before I attempt to read it. A simplified version of my code looks as follows
USING...
I am developing a program to generate json from a dataset that includes several nested temp-tables. When I write the output, the nested temp-tables are written as array objects - something like -> dataLoader": [{"url": "data/266m.csv", "format": "csv", ...}]. Larger json example is below
{...
Hello Mollyfud,
I used the information you provided earlier and put together a program that looks to be working. As it is the first time I written this kind of code they are probably ways to improve the code but for now it looks to be getting the job done. On a high level my latest code looks as...
Hi Mollyfud,
Thank you for the examples especially the one loading data to a temp-table. Gives me a good starting point.
One quick question - how would I go about accessing the nested arrays such as the images and descriptions in the JsonObject?
I need to write a progress program to read data from a JSON file with nested information into a dataset in Progress. I keep getting an error 'Error passing JSON: expected bracket, but found brace (15358)'. How can I update the program to get past this error. I don't have control over the...
-cpinternal UTF-8 -cpstream UTF-8 worked for the files I needed to process. I was able to load all files into temp-tables successful. Thank you for the suggestions.
The session codepage parameters on my machine are set to -cpinternal ISO8859-1 & -cpstream ISO8859-1
I started session with prowin32 -cpinternal UTF-8 -cpstream UTF-8 and the json files without error under on that session.
I have a simple program to read data from a json file into progress temp-tables. Program works well most of the time, but I am running into some data that causes an error as follows
'Unable to convert JSON to native data type for field 'name' in temp-table 'ttregions'. (15363)
Sample data...
Yes this code would be running on WebSpeed.
No there is only one domain. Also the example I provided shows country locations but that is just a simplified version for the code. It is possible for the phone number to change based on other factors such as client balance.
There is only one...
I need to add footer information to several html pages that includes the contact details. The details can vary by customers location and there is a table that contains the information for each location. I am looking for a solution similar to an include file, but that can works on html.
The...
I found and tried the code below but it does not look to be working. I have an installation of OE 11.1 on Windows 2008 Server. Also the vendor will only sent response to a secure HTTPS URL.
{src/web/method/cgidefs.i}
define variable XMLDocHandle as handle no-undo.
define variable...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.