JSON

1K

Solutions

939

Contributors

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

Hi

I am working on an application to access data via API using VB.NET.

I have so far managed to request for and retrieve a security token in the format as shown below:

{"success":true,"token":"eyJhbGciOiJIUzI1NiIsImNhbGciOiJERUYifQ.eNqqVkpOyc9NzMxTslLKTcxJrCzOTDRU0lFKrShQsjI0tTACYjNT01oAAAAA__8.ElaYAGRsAV43lh2OyQ4eR1wF4UIKl7tpHS7YFamVGD8"}

I need to retrieve the "token" value and use that to access the server and request specific information.

I have created a class


Public Class SecurityToken

    <JsonProperty("success")>
    Public Property Success As String

    <JsonProperty("token")>
    Public Property Token As String()

End Class

And in my code, I successfully get to this point where I get the result as shown above


Dim dataStream As Stream = response.GetResponseStream()
Dim reader As StreamReader = New StreamReader(dataStream)
Dim responseFromServer As String = reader.ReadToEnd()

I am stuck at this point in trying to split the result and retrieve just the token to use in further processing.

Any help would be appreciate.

Thank you.
0
I am sending form data to a 3rd party API but get this error:

HTTP/1.1 415 Cannot process the message because the content type 'application/x-www-form-urlencoded' was not the expected type 'text/xml; charset=utf-8'

So, I am trying to troubleshoot by sending the data via Postman but getting the same error. Not really sure how to resolve this? I have been trying to change the content type to text and xml etc. but still keep getting similar errors.

In the headers I have:

Content-Type : application/xml

Not sure if that needs to change
0
Is it possible to convert Excel data to JSON Format? Please give examples particularly using it as input for APIs?
0
I have some issues concerning the sending of the correctly formatted Json data to the serial as per manual description below:
Manual Serial port sending details
All the data will be organized in JSON format starting with package header and ending with checksum. It consists of Header, Command ID, Length of data, Content and Verification Code (CRC):

String: <Header1><Header2><CmdID ><Length ><Content><CRC>

Field                                      Length (Byte)                                             Description

Header 1                              1                                                                   The first byte of package header 0x1A
Header 2                              1                                                                   The second byte of package header Ox5D
CmdID                                  1
                                                                                                                    Command IDs:
                                                                                                                    0x01 acquire the status of ESD
                                                                                                                    0x02 invoice signing
                                                                                                                    0x03 Error code
Length                                  4                                             …
0
Hi All

I have a MS SQL script that runs a stored procedure called [Freak_APITest2] - see script code below

DECLARE @LeaderboardName		varchar		(20)
DECLARE @LeaderboardNameFull	varchar		(20) 
DECLARE @PlayerCount			varchar		(20)
DECLARE @PlayerName				varchar		(20)
DECLARE @Score					nvarchar	(20)
DECLARE @ZombiesKilled			varchar		(15)
DECLARE @Accuracy				varchar		(50)
DECLARE @DamageTaken			varchar		(20)
DECLARE @SecondsInLevel			varchar		(30)
DECLARE @Deaths					varchar		(50)

SELECT top 1 @LeaderboardName        = LeaderboardName		from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'
SELECT top 1  @LeaderboardNameFull	 = LeaderboardNameFull	from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'
SELECT top 1 @PlayerCount	 = PlayerCount					from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'	
SELECT top 1 @PlayerName	 = PlayerName					from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'	
SELECT top 1 @Score	         = Score						from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'	
SELECT top 1 @ZombiesKilled	 = ZombiesKilled				from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'	
SELECT top 1 @Accuracy	     = Accuracy						from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'		
SELECT top 1 @DamageTaken	 = DamageTaken					from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'	
SELECT top 1 @SecondsInLevel = SecondsInLevel				from ScoreBoard		where date	 = '2020-02-04 14:04:38.970'
SELECT top 1 @Deaths		 = Deaths						from ScoreBoard		

Open in new window

0
Hi Guys

Trying to import a json formatted file into sql, the query is below

Declare @JSON varchar(max)
SELECT @JSON=BulkColumn
FROM OPENROWSET (BULK 'C:\Users\szakhour\Desktop\LastScore.json', SINGLE_CLOB) import
SELECT *
FROM OPENJSON (@JSON)
WITH 
(
    LeaderboardName varchar(20), 
    LeaderboardNameFull varchar(20), 
    PlayerCount varchar(20), 
    PlayerName varchar(20), 
    Score nvarchar(20), 
    ScoreDetails varchar(10)
)
CROSS APPLY OPENJSON (ScoreDetails) 
WITH(
		ZombiesKilled varchar(15)'$.ZombiesKilled',
		Accuracy varchar(50)'$.Accuracy',
		DamageTaken varchar(20)'$.DamageTaken',
		SecondsInLevel varchar(30)'$.SecondsInLevel',
		Deaths varchar(50)'$.Deaths' --AS JSON
) 

Open in new window


The json formatted file is below

{
  "LeaderboardName": "Missile base",
  "LeaderboardNameFull": "Missile base four players",
  "PlayerCount": 4,
  "PlayerName": "PLAYER",
  "Score": 35360,
  "ScoreDetails": {
    "ZombiesKilled": "335",
    "Accuracy": "31.32",
    "DamageTaken": "100",
    "SecondsInLevel": "1273",
    "Deaths": "1"
  }
}

Open in new window


When I run the query I get no errors however there is no data. See attached png file called Snip20200203_3.Png, this will show you the result after running the query in MS SQL 2016

Any help is greatly appreciated.
Snip20200203_3.png
0
Hi Guys


I have a file that is formatted in json which generated from a gaming application and saved as a text file on a local machine - the naming of the file always begins with LastScore_xxx_xxx.txt, below is exactly what it looks like

{
  "LeaderboardName": "Missile base",
  "LeaderboardNameFull": "Missile base four players",
  "PlayerCount": 4,
  "PlayerName": "PLAYER",
  "Score": 35360,
  "ScoreDetails": {
    "ZombiesKilled": "335",
    "Accuracy": "31.32",
    "DamageTaken": "100",
    "SecondsInLevel": "1273",
    "Deaths": "1"
  }
}

Open in new window


What I'm trying to do is automate a way where every new file that is generated and saved as text on the local machine to POST automatically to an external database hosted on airtable.

I was able to manually post by extracting the json formatted data within the text file and pasting it into the below

curl -v -X POST https://api.airtable.com/v0/appvFNyUQi9WZWSFH/ScoreTestTable \
  -H "Authorization: Bearer (hidden)" \
  -H "Content-Type: application/json" \
  --data '{
  "records": [
    {
      "fields": {
        "LeaderboardName": "Horde mode trailer park",
        "LeaderboardNameFull": "Horde mode trailer park four players",
        "PlayerCount": 4,
        "PlayerName": "Test Test",
        "Score": 41111,
        "ZombiesKilled": 555,
        "Accuracy": 55.44,
        "DamageTaken": 33,
        "Deaths": 5
      }
    },
    {
      "fields": {
        "LeaderboardName": "Horde mode trailer park",
        "LeaderboardNameFull": "Horde mode trailer park four players",
        "PlayerCount": 4,
        "PlayerName": "Test1",
        "Score": 42000,
        "ZombiesKilled": 999,
        "Accuracy": 99.99,
        "DamageTaken": 10,
        "Deaths": 0
      }
    }
  ]
}'

Open in new window


Just need help to automate this process using Windows, perhaps PowerShell. Any help is greatly appreciated.
0
I can't figure out how to clear a type mismatch error message importing a json file into excel.  I can import through the excel "Data" from web menu with no problem.  When I try to insert json through code I keep getting type mismatch 13 run time error.  I have two modules included with my question.  The first sample module works.   But the second does not work with real code.  This  is the module I need help with.  I have a sample json file included.  Any help would be greatly appreciated.
2modules.txt
samplejsonnnew.txt
0
I'm writing an auto-complete script little by little (html/ plain javascript/ php/ ajax).

I've come across the following code:

var x = document.getElementById(this.id + "autocomplete-list");
if (x) x = x.getElementsByTagName("div");

Open in new window


... and would like to understand this particular bit of the above code

What does the following bit mean? I've never seen logic like this before.

if (x) x  =  


Is this a comparison / some kind of logical operator? I'm wondering if it's a way to detect whether x is NULL and so get information from the immediate parent element. Nevertheless, I'd like to understand what it means.

If so, in 'long English', what does it mean?

Thank you
0
Generally, my thinking is to (1) create two files reCaptcha-test.html and reCaptcha-test.php; (2) prevent.default on the form's submit button, (2) use jQuery submit function to redirect the post to reCaptcha-php for processing. (3) if processing is successful, restore the original form processing, client verification and post to sendForm.php. If reCaptcha processing fails, viewer is referred to a custom error page, failure.htm.

My code is below. It does fetch the reCaptcha token, but my minuscule PHP skills fail after that.  I'm hoping someone can help debug this and point me  in the right direction.

reCaptcha-test.htm

<!doctype html>
<html lang="en" class="no-js">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <title>"reCaptcha v3 Test"</title>

    <script src='https://www.google.com/recaptcha/api.js?render=SITE-KEY-GOES-HERE'></script>
    <script src="./_js/vendor/modernizr/modernizr-custom.js"></script> 

    <link rel="apple-touch-icon" href="./icon.png">
    <link rel="stylesheet" href="./_css/main.css" crossorigin="anonymous">
  </head>

  <body>
   
  
          <div class="c-contact-block-2__form-wrapper">
            <form class="needs-validation form-box" novalidate method="post" action="http://www.themagnolia.com/sendForm.php" name="contactForm" id="contactForm">
            <input type="hidden" name="env_report" 

Open in new window

0
Hi,

I have a textarea with the following list in it 736 4937 587 795 955

1. enter this list in a textarea 736 4937 587 795 955

2.. run my jquery: the output will be this   736, 4937, 587, 795, 955

   var str = $('#ItemList').val();
            str = $('#ItemList').val().replace(/(?:\r\n|\r|\n|\s)/g, ', ');
            $('#ItemList').val(str);

Open in new window



3.  now the user decide to run my jquery again: the user will get this output for running my query again   736,, 4937,, 587,, 795,, 955

4. How can I fix the jquery to say:

if the data in my textarea already has a comma and space between them then don't do anything.

only separate my list if there is no comma followed by a space between them.

I just don't wont the double comma if the user kept on clicking the button.


Thank you for your help,

Lulu50
0
Hi,

I have a textarea where I want the system to replace all the white spaces with a comma.

my code works if I hit the break between each input but if I have my text without hitting the break between each text
it will not replace the white spaces with a comma.

this is what I have:


           var str = $('#ItemList').val();

            str = $('#ItemList').val().replace(/(?:\r\n|\r|\n)/g, ',');
           
            var partsOfStr = str.split(', ');
       
            $('#ItemList').val(partsOfStr);

Open in new window


 Thank you for your help

Lulu
0
Hi

Is there anybody here with an idea of a vendor who is selling some Ms Access VBA books dealing with virtual serial ports using window API with the following features:

Header 1       1       The first byte of package header 0x1A
Header 2       1       The second byte of package header Ox5D
CmdID       1       Command IDs:
0x01 acquire the status of ESD
0x02 invoice signing
0x03 Error code
Length       4       The length of the content, big-endian
Content       ?       The Json based business data
CRC       2       Two-Byte verification (CRC), it will be generated by bytes start from Header 1 up to content

I have seen the code written by Mr David M H. that can only sort out simple connectivity that does not require , the ( Header1,Header2, CmdID & CRC)
Though the last solution to this if the books cannot be found is to buy an already available code.

For Example:

(1) CRC is used to check the parameter from from Header 1 to content  ( 2 byte length)
(2) CmdID is used to ( Open the port, write data & read data) ( 1 byte length)
(3) Header 1 is the starting point or the address package ( 1 byte length)
(4) Header 2 is the of end of address ( 1 byte length)
(5) Length is the length of the content ( 4 byte length)
(6) Content is the Json business data ( ?byte length)
(7) CRC this one is used to check for errors or catch errors ( 2 byte length)

Final code

Below is the final code to be sent to the serial port:

<H eader 1<> H eader 2<> CmdID<> Length <>Content <>CRC>

Open in new window



Regards

Chris
0
Hi, I'm wondoering how to get JSON data from a sql server 2016 column, split out into a table. I've never worked with JSON before, so I'm coming at this like a noob.


Any example would be great.
0
Hi experts,
I have wrote the C# API programe to get data from different location.
All used to work fine.Suddenly it's generating error becuase the records not available
in the API records.(requesting records)There is no way to find Candidate avaiable or not.

see below link how the API request send.

https://test/v3/company/18f62e940d1d01/position/771b0f2aff3c01/candidate/05ea659e456a01/stream

Error:

 500 Internal Server Error
{
    "error": {
        "type": "getStreamError",
        "message": "there was an unknown error getting candidate stream."
    }
}

 string urlCandatestream = "/company/" + CompanyID + "/position/" + positionID + "/candidate/" + candidateID + "/stream";
                var request = new RestRequest(urlCandatestream, Method.GET);


                request.AddHeader("Content-Type", "application/json");
                request.AddHeader("cache-control", "no-cache");
                request.AddHeader("authorization", connectAPI.getAccessToken());
                // rqst.Proxy = GlobalProxySelection.GetEmptyWebProxy();

                IRestResponse response;
                varRequest = request.ToString();
                try
                {
                    response = await _restClent.ExecuteTaskAsync(request);
                    VarRequestResults = response.Content;
                }
                catch (Exception ex)
                {
                    throw new Exception("Error executing  request to " + 

Open in new window

0
Dear Experts!

Here is my problem in Ms Access VBA Code , the code which is supposed to write to the serial port is not fed with data as a result it cannot write anything to the port, below is the actual peice of code that require fixing:

VBA CODE 1

' Write data to serial port.

   
 strData = JsonConverter.ConvertToJson(transaction, Whitespace:=3) & Chr$(13)
    lngStatus = CommWrite(intPortID, strData)
    lngSize = Len(strData)
    If lngStatus <> lngSize Then
    Beep
    MsgBox "No data found"
    ' Handle error.
    End If

Open in new window



Audit proof

If I send the same data to a text file , I'm able to see the actual Json data in text form by using the CODE below:


VBA CODE 2

Dim json As String
Dim theFileName  As Variant
json = JsonConverter.ConvertToJson(transaction, Whitespace:=3) & Chr$(13)
theFileName = "C:\Users\admini\Desktop\Leaders\VBA Json.txt"
Dim handle As Integer
handle = FreeFile
Open theFileName For Output As #handle
Print #handle, json 'jsonSerialization
Close #handle

Open in new window



See also screen shoot which confirms that there is no data at all written the port:

No-data-found.png
0
Im trying to convert an excel file to a JSON for inputting into a database, so I want to select all the data in 'Sheet1' and convert it to JSON, eventually putting it into a file for upload.

Ive managed to get quite far (I think) but I cant seem to get the data range (Line 32)

Code I have soo far is:-
Function Convert-NumberToA1 {   
  Param([parameter(Mandatory=$true)] 
        [int]$number) 
 
  $a1Value = $null 
  While ($number -gt 0) { 
    $multiplier = [int][system.math]::Floor(($number / 26)) 
    $charNumber = $number - ($multiplier * 26) 
    If ($charNumber -eq 0) { $multiplier-- ; $charNumber = 26 } 
    $a1Value = [char]($charNumber + 64) + $a1Value 
    $number = $multiplier 
  } 
  Return $a1Value 
}

Start Excel
$excel = New-Object -comobject Excel.Application

#open file
$FilePath = 'C:\Temp\Current Mailbox Inventory.xlsx'
$workbook = $excel.Workbooks.Open($FilePath)

$WorkSheet = $WorkBook.sheets.item("Sheet1")


$lastRow = $WorkSheet.UsedRange.Rows.count
$lastCol = $WorkSheet.UsedRange.Columns.count

$lastCol = Convert-NumberToA1 -number $lastCol


$data = $WorkSheet.Range("A1:$lastCol$lastRow").Value
#write-host $data


$myJson =  $data | ConvertTo-Json
write-host $myJson
#write-host "A1:$lastCol$lastRow"

Open in new window


Im VERY new to Powershell, you can count the number of scripts Ive got working on one hand :-S

Can anyone give me any pointers as to where Im going wrong please?
0
I need to understand how to cast a complex deserialized  Json object to enumerable so that it can be bound to an a gridview

           var enumerable = new[] { GetBuilds().Result};
                       

            GridView1.DataSource = enumerable;
            GridView1.DataBind();

Open in new window




2020-01-13_11-28-21.png


Currently it only results in the top node, i need to get the data in the fields node.

2020-01-13_11-29-37.png
0
Dear Experts,

I use PHP and get the data like below.

$obj  = json_decode($server_output);

echo $output= $obj->result;

//the out put is:
{"CancelReturnCode":0,"CancelReturnData":"VPS-50026","ReferenceCode":"991770","Jcode":"123456","TimeStamp":"13.01.2020 15:17:37"}
 
 How can I get the result of the Jcode? thank you
0
Dear All;
I need some help to construct a better VBA filter in Ms Access on the Arrays, I remember one helped me here, but unfortunately, I have misplaced the code. The objectives of the code are listed below:
(1)      If no data found in the record source, then both the object and value pair should disappear in the Json string (The string should show white space or blank ONLY) I do NOT want it to return either (null or “”) never.
(2)      If data is found in the record source, then both the object and value pair found should show in the Json string , example (
“States in Africa”,53

Open in new window

)

Current Code:

dict.Add fld.Name, rs.fields(fld.Name).value

Open in new window


Required amendments:

dict.Add fld.Name, iif(rs.fields(fld.Name).Value = Null,Me.remove, rs.fields(fld.Name).Value)

Open in new window


The problem here is that the me.remove doesn’t work! That is where I have a problem.
Your help will be appreciated.
0
In formatting   Json we are required Not to show null (But “ “) for any control that has empty value , how do we archive it using VBA code:

Private Sub CmdConertJson_Click()
  On Error GoTo Err_Handler
  Dim db As DAO.Database
  Dim rs As DAO.Recordset
  Dim fld As DAO.Field
  Dim qdf As DAO.QueryDef
  Dim prm As DAO.Parameter
  Dim root As Dictionary
  Set root = New Dictionary
    Dim transaction As Dictionary
    Dim transactions As Collection
    Dim item As Dictionary
    Dim items As Collection
    Dim Tax As Collection
    Dim Z As Integer
    Dim i As Long
    Dim j As Long
    Dim t As Long
    Set transactions = New Collection
  Set db = CurrentDb
  Set qdf = db.QueryDefs("QryJson")
For Each prm In qdf.Parameters
    prm = Eval(prm.Name)
Next prm
Set rs = qdf.OpenRecordset(dbOpenSnapshot, dbSeeChanges)

Set qdf = Nothing
 rs.MoveFirst
    Do While Not rs.EOF
        Set transaction = New Dictionary
        transaction.Add "BuyerName", Me.BuyerName
        transaction.Add "BuyerTaxAccountName", Me.BuyerTaxAccountName

For example if Me.BuyerName has EMPTY the json should show “ “  NOT null
“BuyerName”, “ ”
“BuyerTaxAccountName”,” ”

Open in new window



Kindly help
0
Dear All;

Happy new year 2020!

I just want to be corrected on the Ms Access/VBA code below if I have gotten it right or there is an error somewhere , the quality may not be as per your expectation , but due to the impending scheduled quality check  by the taxman on their tax gadget (Rs 232 serial port) coming on Monday next week , I have decided to use this platform to audit the code below:
    Dim json As String
    Dim intPortID As Integer ' Ex. 1, 2, 3, 4 for COM1 - COM4
    Dim lngStatus As Long
    Dim strError  As String
    Dim strData   As String
    Dim lngSize As Long
    intPortID = 2
    ' Initialize Communications
    lngStatus = CommOpen(intPortID, "COM" & CStr(intPortID), _
        "baud=115200 parity=N data=8 stop=1")
    
    If lngStatus <> 0 Then
    ' Handle error.
        lngStatus = CommGetError(strError)
    MsgBox "COM Error: " & strError
    End If
    

    ' Set modem control lines.
    lngStatus = CommSetLine(intPortID, LINE_RTS, True)
    lngStatus = CommSetLine(intPortID, LINE_DTR, True)

    ' Write data to serial port.
    strData = JsonConverter.ConvertToJson(transaction, Whitespace:=3) [b]‘the intention here is to put ‘the Json data into the data string called    strData[/b]
    lngSize = Len(strData)
    lngStatus = CommWrite(intPortID, strData)
    If lngStatus <> lngSize Then
    ' Handle error.
    End If
Exit_CmdConertJson_Click:
Exit Sub
Err_Handler:
Resume Exit_CmdConertJson_Click

' Read maximum of 14400 bytes from serial

Open in new window

0
I have a json file which has some information in as:-
$json.Hardware.'Network Adapters'.'Network Adapter 1'.'MAC Address'
$json.Hardware.'Network Adapters'.'Network Adapter 2'.'MAC Address'
$json.Hardware.'Network Adapters'.'Network Adapter 3'.'MAC Address'
$json.Hardware.'Network Adapters'.'Network Adapter 4'.'MAC Address'
$json.Hardware.'Network Adapters'.'Network Adapter 5'.'MAC Address'

Open in new window


I need to pull out the information, so thought about using a for loop:-
for ($x=1; $x -le 10; $x++) {
    if ($json.Hardware.'Network Adapters'.'Network Adapter $x'.Type -contains 'Wired*') {
        Write-Host "MAC Wired - " $json.Hardware.'Network Adapters'.'Network Adapter $x'.'MAC Address'
    }
}

Open in new window


But it isnt working. Im assuming Im not concatinating the $x in the variable name correctly, but tried to put it outside the loop as a variable, but that doesnt work.

Any ideas?
0
On the tax labels in the Json code (Ms Access VBA) below, I want to hide the control field in Tax Class B if it does not contain a value in the final Json string or code. Currently it is showing a “Null” but unfortunately the machine cannot accept that, it should NEVER show at all cost.
If an event where all the two tax labels are having values then the actual labels attached to the controls must show the actual value, if not then no show.

Please check line 26 in the code below

{
"PosSerialNumber": "16777773",
"IssueTime": "20190101201045",
"TransactionType": 0,
"PaymentMode": 0,
"SaleType": 0,
"LocalPurchaseOrder": "ZRP568930082",
"Cashier": "CHRIS",
"BuyerTPIN": "199863289426",
"BuyerName": "Inspur",
"BuyerTaxAccountName": "Western Ville",
"BuyerAddress": "Eagles Nest ",
"BuyerTel": "+5869302179940",
"OriginalInvoiceCode": null,
"OriginalInvoiceNumber":null,
"Items": [
{
"ItemId": 1,
"Description": "Fruit Drink",
"BarCode": "783692456300",
"Quantity": 8,
"UnitPrice": 2,
"Discount": 0,
"TaxLabels": [
"A",
"null"
],
"TotalAmount": 16,
"isTaxInclusive": true,
"RRP": 0
}
]
}

Open in new window



If it was on an Ms Access Form, I can achieve this by doing it this way:
 
If IsNull(Me.TaxClassB)Then
Me.TaxCassB.Visible = False
End If

Open in new window


How about where VBA is feed Json, how can we withhold Null Values so that we avoid the Null values on the Json String? I tried the code below its NOT working at all.

Dim myvar As Variant
 Tax.Add ( myvar = DLookup("TaxClassB", "QryJson", "InvoiceID =" & Me.InvoiceID & " AND ItemesID =" & CStr(i)))
    If Not IsNull(myvar) Then
        If Len(myvar) > 0 Then
            Tax.Add myvar
        End If
    End If

Open in new window

0
I've been trying to parse an incoming POST that is as below in Laravel. Its apparently a json array containing an object.
Tried a number of things like json_decode and so on

How in laravel would I receive the incoming POST and say get at the account_id for example??
{
"deltas": [{
"date": 1577127539, 
"object": "message", 
"type": "message.created", 
"object_data": {
"namespace_id": "93d6z2qmxm050zh2znnp90afs", 
"account_id": "93d6z2qmxm050zh2znnp90afs", 
"object": "message", 
"attributes": {
"thread_id": "6ejmdhd2p0iyhscfac214xins", 
"received_date": 1577127517}, 
"id": "ioe47mlrjm592gbrc01c2tks", "metadata": null
}
}]
}

Open in new window

Thanks in advance for any help.
0

JSON

1K

Solutions

939

Contributors

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.

Related Topics