Discussions tagged JSON
Good day Appeon Support....
I need your help... what will I do if I get this kind of message? My work around is sending messages by ExportRowAsJson... I want to send it all at once. I used dw_1.ExportJson() but this is the response received.
...
How to send data using HTTP Client after token was send.
- Resolved
- How-to
- Last updated 3 months ago
- Daryl Foster replied 3 months ago
Hello Appeon Support,
Good day!!!
I need your help, I currently working on a SMS blast project... I am using the HTTPClient and successfully retrieve the token, however, I cannot send data using POST method to send SMS to the server...
...
JWT TOKEN - authentication
- Resolved
- How-to
- Last updated 4 months ago
- Daryl Foster replied 3 months ago
HI APPEON Support,
Good day... I need your help badly... I am new in API and REST... need guidance. Our company is implementing SMS Blast..
Authentication is give by the provider company.
Basic Authentication in the HTTP head...
Re: ImportJSONByKey fails on compiled project
- How-to
- Last updated 4 months ago
- Matt Balent replied 4 months 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 4 months ago
- Andreas Mykonios replied 4 months 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 4 months ago
- Sivaprakash BKR replied 4 months 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 6 months ago
- Andreas Mykonios replied 6 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 7 months ago
- Ken Guo @Appeon replied 7 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 9 months ago
- mike S replied 9 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 11 months ago
- Mark Lee @Appeon replied 11 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 12 months ago
- Logan Liu @Appeon replied 12 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 1 year ago
- Ken Guo @Appeon replied 1 year 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...
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 1 year ago
- Daryl Foster replied 1 year 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 2 years ago
- Andreas Mykonios replied 2 years 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 2 years ago
- Chris Pollach @Appeon replied 2 years 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...
- Page :
- 1