Discussions tagged JSON
Re: ImportJSONByKey fails on compiled project
- How-to
- Last updated 1 week ago
- Matt Balent replied 2 days ago
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...
JSON Packager - Setting Array Values
- Resolved
- How-to
- Last updated 2 weeks ago
- Andreas Mykonios replied 2 weeks ago
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...
How to edit .json that contains nested objects?
- Resolved
- How-to
- Last updated 2 weeks ago
- Sivaprakash BKR replied 2 weeks ago
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...
PowerBuilder 12.5 creating Json Files
- Advice
- Last updated 2 months ago
- Andreas Mykonios replied 2 months ago
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...
Loadstring method on JSONpackage with multi-element JSON array
- Resolved
- How-to
- Last updated 3 months ago
- Ken Guo @Appeon replied 3 months ago
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...
JSONPackage GetValue returning the second set not the first
- How-to
- Last updated 5 months ago
- mike S replied 5 months ago
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...
Handling special and reserved character while working with JSON using JSONGenerator and JSONParser.
- Resolved
- How-to
- Last updated 7 months ago
- Mark Lee @Appeon replied 7 months ago
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...
How to use nested Json data class?
- How-to
- Last updated 8 months ago
- Logan Liu @Appeon replied 8 months ago
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...
Any way to handle JSON with more than 20 MB?
- How-to
- Last updated 9 months ago
- Ken Guo @Appeon replied 9 months ago
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...
Convert JSON to usable data
- How-to
- Last updated 10 months ago
- Chris Pollach @Appeon replied 10 months ago
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...
How to PostData using HTTPClient and how to read the result
- Resolved
- How-to
- Last updated 10 months ago
- Daryl Foster replied 10 months ago
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 =...
POST content-type application/json: max. Textsize 32K?
- Resolved
- How-to
- Last updated 1 year ago
- David Xiong @Appeon replied 1 year ago
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...
JsonImport trim trailing white spaces
- Issue
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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...
Background colour of a dropdown datawindow (using theme)
- How-to
- Last updated 1 year ago
- Andreas Mykonios replied 1 year ago
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 =...
ImportJson method on Datawindow
- Resolved
- How-to
- Last updated 1 year ago
- Chris Pollach @Appeon replied 1 year ago
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...
PowerBuilder Theme how to have a similar window title bar?
- How-to
- Last updated 2 years ago
- Ken Guo @Appeon replied 2 years ago
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