Discussions tagged JSON

Hello, PB 2022 B 1892 In one of my projects, ImportJSONByKey fails to import data when run from exe.  The same JSON string imports successfully when run from the IDE.  The command used to import JSON is li_rc = ids_setup.ImportJSONByKey(ls_ret_jso...
Attempting to achieve in the JSON output, the following specification... "streetLines": [ "PLACEHLDR_SHIPPER_ADDRESS_LINE_1", "PLACEHLDR_SHIPPER_ADDRESS_LINE_2" ], Trying... ljp_address.setvalue( "streetLines", "[ 'PLACEHLDR_SHIPPER_ADDRESS_LINE_1...
Hi, I am working on a few different things at the moment, JSON being one of them. I was wondering how can I edit my JSON file that has nested objects (i think that's the correct the term). In other words, a JSON structure that looks like this. { ...
Hello PB 2022 build 1892 Need to export data from a datawindow to three different JSON string. 1.  All deleted rows2.  All modified rows3.  All inserted rows For deleted rows:     dw_1.ExportJSON(Delete!, 1, 0, 1, 5)  Works! For 2 & 3, there...
Hello, We are developing in PowerBuilder 12.5 and I'm looking to find the best way to create a Json file format. Currently we are writing the data using a function out to a text file, Is there any way in PB 12.5 to create a json file with the format...
So I have a JSON string I'd like to load into a JSONpackage object for further processing.  Problem is (apparently) it is an array which I guess the JSONPackage object cannot handle.  I get this error: Failed to load the JSON data because its root no...
I am trying to parse the return JSON statement from an online credit card company.  The result Json I get back is the following (please note this is from their sandbox using their sample data). { "transactionResponse": { "responseCode": "1", "authCo...
Hello Appeon Team, I am working to create the JSON using JSONGenerator and then making httpclient call to send those Json file as payload. We have frontend screen to take JSON fields value like comment, sales number, qty etc. The comment box is a te...
Hi all, I am trying to work on API service for our ERP system Invenotry function, need make use of nested Json structure to pass values: using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Newtonso...
Hi, is there any way to handle JSON with more than 20 MB?  We want to create a Webservice in SnapDevelop, that sends or retrieves E-Mails. Our application sends the data to the Webservice and the Webservice sends the E-Mail or the retrieves them. T...
I hope someone can help I need to store the return from my GET statement into a database table This is the format of the return, what method would you recommend. I am currently using 2019 but can easily move to 2021 if the new features help. regar...
Hello, Need to PostData to a URL and read the result.   My code to PostData is and Read the response is String ls_email, ls_einvoice_json ls_email = test@test.com ls_einvoice_json = /*JSONVALUE*/ This JSON is verified to work ls_url =...
Hi, I'm beeing writing a small WEB-API which has to process POSTed metadata and files as json-data and insert it into a SQL Server database. I know, the client could send the data and files together in one POST using the content-type form-data.  B...
SQL Server setting is "ansi_padding"=ON and using JSONIMPORT to import data into datawindow but wherever data type of column in SQL server is CHAR, trailing spaces are coming. If we don't use JSONImport functionality to import data into Datawindow s...
Hello, Using PB 2019R3 Build 2703 - Using Theme Flat Design Blue Need to set a (different) background color for dropdowndatawindow from datawindow.  Having the same background color for both datawindow and dropdown datawindow is bit confusing. Fla...
  Good afternoon, I have a DataWindows that I want to take to Json, but the problem is that it is not respecting the upper and lower case of the headers. How was this solved?   //ls_json_resultado = lds_select.ExportJson( ) ls_json_resultado =...
Okay, so I have the following JSON: { "PATIENT_CASE": [ { "CaseDate": "03/05/2021", "NatureofCase": "Abdomen Injury", "CaseClosed": "No", "CaseID": 1261106365, "CenterID": 4716, "SortDate": "2021/03/05", "PatientID": 1261070650, "Hipaa": "No", "Desc...
Hello All, on windows server running a EXE the exportJson retunrs and empty string all the other features are working do we need any aditional DLL other than the ones of the runtime packager and the C++ runtime?...
Hello, I was wondering if anybody knows whether the Pipeline object will be capable of reading data from json files in near future. Best regards,Konstantin...
Hi Guys anyone of you knows if is possible configuring theme file .json in order to have this window title bar:   As you can see there is a color gradient and yellow row a the bottom...   Thanks in advance ...
  • Page :
  • 1