JSON

999

Solutions

910

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Expert

How to create endpoint  webhooks?
any idea much appreciated.
0
Exploring ASP.NET Core: Fundamentals
LVL 19
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Hi Expert,
I have advice to use Webhook to get data and they provided the Json file.see below.
But i need to understand how to get data from server. for example how to write the code (c#)for when candidateStatusUpdated updated how i catch the data.
I understand server will send data. so i need to understand what are the steps i have to use.



{
    "_id" : String,
    "type" : "candidateStatusUpdated",
    "object" : {
        "company" : {
            "_id" : String,
            "name" : String,
            "friendly_id" : String,
        },
        "position" : {
            "_id" : String,
            "name" : String,
            "location" : {
                "name" : String
            },
        },
        "stage_was" : {
            "id" : String,
            "name" : String
        },
        "entered_previous_stage" : Date,
        "stage" : {
            "id" : String,
            "name" : String
        },
        "entered_stage" : Date,
        "candidate" : {
            "_id" : String,
            "name" : String,
            "email_address" : String,
            "phone_number" : String,
            "profile_photo_url" : String,
        },
        "acting_user" : {
            "_id" : String,
            "email_address" : String,
            "name" : String
        },
        "time_in_previous_stage" : Number,
    },
    "creation_date" : Date
}

Open in new window

0
Hi Expert,
I'm geeting error in the object "Invalid token 'object' in class, struct, or interface member declaration"

but if i changed to _object it's no error but no records showing
any idea how to use this Json results. I will really appriciated if any one show me where i'm doing mistake.

public Object object { get; set; }


Json results
 [
    {
        "_id": "weew",
        "type": "companyNotePosted",
        "stream_id": "ewewe",
        "object": {
            "body": "dsfdf",
            "attachments": [],
            "company_id": "eerer",
            "acting_user": {
                "_id": "4444",
                "email_address": "erer",
                "name": "ere",
                "username": "rere",
                "initial": "G",
                "creation_date": "2018-01-18T15:15:39.704Z",
                "verified_email": true,
                "updated_date": "2019-06-28T08:54:02.820Z"
            },
            "mentioned": {
                "7c017c82d5a9": {
                    "_id": "7c017c82d5a9",
                    "email_address": "errer",
                    "hex_color": "color3",
                    "initial": "s",
                    "name": "ffff",
                    "tz_offset": -60,
                    "creation_date": "2019-05-08T08:32:35.570Z",
                    "terms": "2019-06-05T13:15:52.406Z",
                    "username": "ffff",
                    "notification_settings": {
                        

Open in new window

0
Hi Experts,

I have added Content-Type to application/json But it's returning Content-Type : text/xml; charset=UTF-8
How to get the Json type. I have tested in the Post man

when i'm calling from C# progarme it's working fine,But it's not working in the Post man API and sharepoint 365 flow
0
I had this question after viewing Copy/Move AWS meta infrastructure.
Looking into the same issue and note that this question is close to two years old.
Have there been some tools appearing that will translate an existing cloud infrastructure into json code?
0
I want to build a Power BI  report which connects to SQL data source but has wants to use Json data which is one of the field in a SQL table. I can directly connect to JSON file which i am aware. Any help will be appreciated.
0
Dear Experts!

Thank you so much for the previous and current help on this Ms Access VBA Topic , I still need your assistance on how to get or pull all the data from the sub form called [sfrmInvoicedetails Subform] for my string Json string. The little salvage over the internet it appears I'm required to use EOF & BOF, frankly I'm not sure how to use these functions in VBA.

Final working code and approved see below:


Private Sub CmdSales_Click()
  
Dim foo As New Dictionary
Set foo = New Dictionary
Dim Noor As Dictionary
Set Noor = New Dictionary
Dim hoo As New Collection
Dim goo As New Dictionary
Set goo = New Dictionary
Dim Zoo As New Dictionary
Set Zoo = New Dictionary
Dim Koo As New Collection
Dim Too As New Collection
    With foo
        .Add "PosSerialNumber", Me.INV
        .Add "IssueTime", Me.InvoiceDate
        .Add "Customer", Me.Customer.Column(1)
        .Add "TransactionTyp", 0
        .Add "PaymentMode", 0
        .Add "SaleType", 0
        .Add "Items", Koo
     Koo.Add Noor
     Noor.Add "ItemID", 1
     Noor.Add "Description", Forms!frmInvoice![sfrmInvoicedetails Subform]!Description.Column(1)
     Noor.Add "BarCode", "4589630036"
     Noor.Add "Quantity", Forms!frmInvoice![sfrmInvoicedetails Subform]!Qty
     Noor.Add "UnitPrice", Forms!frmInvoice![sfrmInvoicedetails Subform]!UnitPrice
     Noor.Add "Discount", Forms!frmInvoice![sfrmInvoicedetails Subform]!Discount
     Noor.Add "Taxable", hoo
     hoo.Add 

Open in new window

0
I have 2 modules in React that contain a material-ui form and I am struggling to get the SelectField to update the state. Text inputs work fine, but I just can't get the SelectField to work. Can anyone help me as this is driving me insane!

Module 1(UserForm.js - This is where module 2 is displayed

====================================================

import React, { Component } from 'react';
import FormUserDetails from './FormUserDetails';
import FormPersonalDetails from './FormPersonalDetails';
import Confirm from './Confirm';
import Success from './Success';

export class UserForm extends Component {
  state = {
    step: 1,
    firstName: '',
    lastName: '',
    email: '',
    occupation: '',
    city: '',
    bio: '',
    test1: ''
  };

  // Proceed to next step
  nextStep = () => {
    const { step } = this.state;
    this.setState({
      step: step + 1
    });
  };

  // Go back to prev step
  prevStep = () => {
    const { step } = this.state;
    this.setState({
      step: step - 1
    });
  };

  // Handle fields change
  handleChange = input => e => {
    this.setState({ [input]: e.target.value });
  };

  //This is where the select is handled and I suspect is where the problem is

  handleSelect = SelectField => e => {
    this.setState({ [SelectField]: e.target.value });
  };

  render() {
    console.log(this.state.test1);
    const { step } = this.state;
    const {
      firstName,
      lastName,
      email,
      occupation,
      city,
  

Open in new window

0
Hi Experts,
I would like to extract the pay_interval field value from the JSON array into MYSQL syntax :
[
  {
    "111_id": 238777,
    "222_no": "I-86605",
    "333_item": [
      {
        "444": "Contract Rate",
        "555": "Hours",
        "666": "210.00",
        "777": "12.00",
        "888": "17.50",
        "999": "42.00",
        "2222": "252.00",
        "3456": "1234invoice_no": "INV-1",
        "54345": "90"
      }
    ],
    "pay_interval": 1,
    "888": "Unpaid",
    "t999": 210,
    "000_id": 29669,
    "234_id": 4393
  }
]

Open in new window

Any help would be appreciated
Thanks
0
I have this string in json {"columnC":"1","columnA":"2","columnB":"2"}
How can I use for loop to generate  like

ColumnC: 1
ColumnA: 2
ColumnB: 2

Thanks
0
Introduction to R
LVL 19
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

I have Json & MVC / c# question below:

the var json = JSON.stringify(data); return json format
like {"column":"1","columnA":"2"}

My question is inside of the C# mvc ReceiveJson: How to extract the value like

column = 1
columnA = 2

and i want to be like insert table column, columnA values (1,2)

And {"column":"1","columnA":"2"} is it a json format?

*** formdiv *** inside of it, it just a combination of some <input id='column'> or <select id='columnA'>
function Submit(domain) {
    var x = $('#formdiv *').serializeArray();
    var data = {};
    $.each(x, function (i, field) {
        data[field.name] = field.value;
    });
    var json = JSON.stringify(data);
    alert(json);
    $.ajax({
        url: domain + "/Api/ReceiveJson",
        type: "POST",
        data: {
            'message': json
        },
        dataType: 'json',
        success: function (data) {
            alert(data.BondCode);
        },
        error: function (msg) { alert(msg); }
    });
    return false;
}

[HttpPost]
        public JsonResult ReceiveJson(List<string> message)
        {             
            var jsonResult = Json(message);
            domainCompanyBondType.BondCode = "1";
            return Json(domainCompanyBondType, JsonRequestBehavior.AllowGet);
        }

Open in new window

0
I have a thirdparty rest api and angular js frontend project that I inherited.

data is in json, and the code iterates over the collection and displays it.
as I don't have control over the api and what it returns , I want to hide certain items in the collections.

what are my options in angularjs?
0
Dear Experts

Kindly see how you can help again in my final part of this Ms Access /Json project, now I want the data in the query below to be posted to the site as per link in the VBA. The problem I have right now is how to format the data in a query into Json so that it can be posted successfully
Qry1
SELECT tblInvoice.Customer, tblCustomers.TaxID, tblCustomers.Address, tblInvoice.INV, tblInvoice.InvoiceDate, tblInvoicedetails.Product, tblInvoicedetails.Qty, tblInvoicedetails.Price, tblInvoicedetails.VAT, (([Qty]*[Price])*(1+[VAT])) AS TotalPrice
FROM tblProducts INNER JOIN ((tblCustomers INNER JOIN tblInvoice ON tblCustomers.ID = tblInvoice.Customer) INNER JOIN tblInvoicedetails ON tblInvoice.INV = tblInvoicedetails.INV) ON tblProducts.PDID = tblInvoicedetails.Product
WHERE (((tblInvoice.INV)=[Forms]![frmInvoice]![INV]));

Open in new window


Below is the VBA that I have prepared requiring completing the Json data formatting:

Private Sub CmdSales_Click()
Dim http As Object
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Dim JSON As Object
Dim i As Integer
Dim item As Object
Set rs = db.OpenRecordset("SELECT * FROM Qry1 Where Qry1.ID = " & Me.INV, dbOpenDynaset, dbSeeChanges)
http.Open "POST", "http://jsonplaceholder.typicode.com/users/?id=" & Me.INV, False
http.send
Set JSON = ParseJson(http.responseText)
i = 2
End Sub

Open in new window

Kindly see how this can be done!
1
I'm trying to figure out how to serialize an array of java objects and post as json with jax-rs ClientBuilder using jersey and/or jackson.

I'm using the ClientBuilder to do a post. If for example you have an Arraylist of Car objects

List<Car> cars = new ArrayList<>();

Open in new window

And I want to do something like:

Response response = ClientBuilder
.newClient.target(url)
.request()
.accept(MediaType.APPLICATION_JSON)
.post(Entity.json(cars));

Open in new window

and post exactly this as the payload

[{"brand": "toyota"}]

Open in new window

How would I need to implement the Car object? And how would I need to setup my ClientBuilder chain properly?
0
Need to change a value in a Package.json file that looks like this
package.json  
{
  "name": "Test",
  "version": "0.1.0",
  "repository": {
    "type": "git",
    "url": "git@github.com/test.git
  },
  "license": "UNLICENSED",
  "private": true,
  "devDependencies": {
    "chromedriver: "75"
}


Below code gives me chrome driver version 75
CHROME_VERSION=$(cat package.json \
  | grep chromedriver \
  | head -1 \
  | awk -F: '{ print $2 }' \
  | sed 's/[",]//g')

echo $CHROME_VERSION


Using a bash script - can anyone help me with how to update the value from 75 to 76?

I need to update the chrome driver version from 75 to 76. (Update the chrome driver version from 75 to 76)
0
Hi;

I am trying to get value of loglevel and logType from below json logs of ElasticSearch by using Nest Code. LogLevel should be "ERROR" LogType should be "Response". How can I write this Nest query. I think that Nest is Really difficult.


            var settings = new connectionsettings(new uri("http://localhost:9200")).defaultındex("mylog-2019-07-29");

            var client = new elasticclient(settings);

            var searchresponse = client.search<rootobject>(s => s
                                            .allındices()
                                            .from(0)
                                            .size(10)
                                            .query(q => q
                                                 .match(m => m
                                                    .field(f => f.logLevel)
                                                    .query("Error")
                                                 )
                                            ));

            var r3 = client.search<rootobject>(search => search.matchall().ındex("mylog-2019-07-29")).documents;

			// OR 
            var result = client.search<rootobject>(q => q.allındices());
            var result2 = result.hits;

            using (httpclient client = new httpclient())
            {
                var result = await client.getasync("http://localhost:9200");

                var data = 

Open in new window

0
Hi, I have json string and I want to parse in vb.Net so I can select individual values, What will be simplest way to do that, I am attaching my code
Dim serviceUrl As String = "http://localhost:61210/Webservice/PService.svc"
        Dim input As Object = New With { _
                        .UserId = "14"
        }
        Dim inputJson As String = (New JavaScriptSerializer()).Serialize(input)

        Dim httpRequest As HttpWebRequest = DirectCast(WebRequest.Create(New Uri(serviceUrl & "/InsertLogInLog")), HttpWebRequest)
        httpRequest.Accept = "application/json"
        httpRequest.ContentType = "application/json"
        httpRequest.Method = "POST"

        Dim bytes As Byte() = Encoding.UTF8.GetBytes(inputJson)

        Using stream As IO.Stream = httpRequest.GetRequestStream()
            stream.Write(bytes, 0, bytes.Length)
            stream.Close()
        End Using
        Dim strText As String

        Using httpResponse As HttpWebResponse = DirectCast(httpRequest.GetResponse(), HttpWebResponse)
            Using stream As IO.Stream = httpResponse.GetResponseStream()
                strText = (New StreamReader(stream)).ReadToEnd()
            End Using
        End Using

Open in new window

0
I am using ASP.NET 4.7 (not ASP.NET Core) to design a web page, which receive Webhook request from Dialogflow. I use following code to extract the JSON data from request.

using (var reader = new StreamReader(Request.InputStream))
{
    string reqString = reader.ReadToEnd();
}

Open in new window


However, I found the double quotes in the original request are missing in the content. Original message is

{"responseId":"0b0b6903-60be-4fdf-919b-f20103bfd1ec-21947381","queryResult":{"queryText":"I need to book a hotel room with queen size bed.","parameters":{"size":"queen"},"allRequiredParamsPresent":true,"fulfillmentMessages":[{"text":{"text":[""]}}],"intent":{"name":"projects/aets-mknkjs/agent/intents/1727505d-2499-42c4-95ec-7385b5da17a3","displayName":"hotelbooking"},"intentDetectionConfidence":0.7410408,"languageCode":"en"},"originalDetectIntentRequest":{"payload":{}},"session":"projects/aets-mknkjs/agent/sessions/d55e1ae8-c5d3-1ecf-7d6a-9f27391b6b6c"}

Open in new window


But I extracted from Request.InputStream does not have double quotes.

{responseId:0b0b6903-60be-4fdf-919b-f20103bfd1ec-21947381,
queryResult:{queryText:I need to book a hotel room with queen size bed.,
parameters:{size:queen},
allRequiredParamsPresent:true,
fulfillmentMessages:[{text:{text:[]}}],intent:{name:projects/aets-mknkjs/agent/intents/1727505d-2499-42c4-95ec-7385b5da17a3,displayName:hotelbooking},intentDetectionConfidence:0.7410408,languageCode:en},originalDetectIntentRequest:{payload:{}},session:projects/aets-mknkjs/agent/sessions/d55e1ae8-c5d3-1ecf-7d6a-9f27391b6b6c}

Open in new window


How can I retain or extract the orginal message content?
0
Hi Experts!

I have been using DataSnap REST for some weeks but I have problems understanding some concepts related to TJSONObject and how these data are sent.
I have three related questions.
I consider a simple class:


TMyclass = class
  private
    [JSONName('name')] // invio
    Fname: string;
    [JSONName('surname')] // invio
    Fsurname: string;
    [JSONName('mytext')] // invio
    Fmytext: string;

    procedure Setname(const Value: string);
    procedure Setsurname(const Value: string);
    procedure Setmytext(const Value: string);
  public
    property name: string read Fname write Setname;
    property surname: string read Fsurname write Setsurname;
    property mytext: string read Fmytext write Setmytext;
  end;
  
.....

procedure TMyclass.Setname(const Value: string);
begin
  Fname := Value;
end;

procedure TMyclass.Setsurname(const Value: string);
begin
  Fsurname := Value;
end;

procedure TMyclass.Setmytext(const Value: string);
begin
  Fmytext := Value;
end;  

Open in new window


.....

In my code I have something similar to:

Procedure TMain.Send_JSON;
var
   VJSONObject: TJSONObject;
   VMyclass:TMyclass;
begin
   VMyclass:=TMyclass.Create;

   VMyclass.name:='John';
   VMyclass.surname:='Ace';
   VMyclass.mytext:='';

   VJSONObject:=TJson.ObjectToJsonObject(VMyclass);
   //...
   
   RESTClient1.ResetToDefaults;
   RESTRequest1.ResetToDefaults;
   RESTResponse1.ResetToDefaults;
   RESTClient1.BaseURL:='http://111.222.333.444:8080/datasnap/rest/mypath';
   RESTRequest1.Timeout:=RESTRequest_Timeout;
   
   RESTRequest1.Resource:='/MyParam'; 
   RESTRequest1.Method:=TRESTRequestMethod.rmPOST; 
   RESTRequest1.AddBody(VJSONObject.ToJSON, ContentTypeFromString('application/json'));
   //...
   RESTRequest1.Execute;
   //...
end;

Open in new window



[First question]
When I send this JSON:
         {"name":"John","surname":"Ace","mytext":""}
i don't want to have:
"mytext":""
in the JSON.

[Second question]
I don't know a way to insert a JSON array like this:
{"name":"John","file": [{"name_file":"myfile1.txt","dir_file":"C:\mydir"},{"name_file":"myfile2.txt","dir_file":"C:\mydir2"},...]}

[Third question]
I am looking for a method to manipulate the:

VJSONObject.ToString

before insert in the:

RESTRequest1.AddBody(VJSONObject.ToJSON,...

but I couldn't find it. I search something like:

  VJSONObject := Json.StringToJsonObject(VJSONObject.ToString);

I have a lot of problems because there is no documentation on this part.
Does anyone have a solution?


Working with RAD Studio Tokyo 10.2.3
0
OWASP: Forgery and Phishing
LVL 19
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

I need to create dynamic Google Charts which gets the data from a DB stored procedure. I have managed to spit out the actual table with the function below.
var ajax = new XMLHttpRequest();
            var method = "GET";
            var url = "data.php";
            var asynchronous = true;
            ajax.open(method, url, asynchronous);

            //sending ajax request
            ajax.send();            

            // receiving response from data.php
            ajax.onreadystatechange = function()
            {
                if (this.readyState == 4 && this.status == 200)
                {
                    //converting JSON back to array
                    var dataTable = JSON.parse(this.responseText);
                    console.log(dataTable); // for debugging

                    // html value for <tbody>
                    var html = "";
                    // looping through the data
                    for (var a = 0; a < dataTable.length; a++)
                    {
                        var categoryValue = dataTable[a].Category;
                        var monthJan = dataTable[a].Month1;
                        var monthFeb = dataTable[a].Month2;
                        var monthMar = dataTable[a].Month3;
                        var monthApr = dataTable[a].Month4;
                        var monthMay = dataTable[a].Month5;


                        // appending at HTML
                        html += "<tr>";
                        html += 

Open in new window

0
I am attempting to scrape the following URL:

https://www.oddsportal.com/soccer/england/premier-league/liverpool-norwich-4IMoMG3q/

Using the Network tab in Chrome's developer tools, you can see there is an API that feeds the data into the website - which is in the form of a JSON - and looks as below. This data is what I am trying to scrape.

https://fb.oddsportal.com/feed/match/1-1-4IMoMG3q-5-2-yj1e3.dat?_=1562831112277

This is the code I am currently trying to scrape this with:

from selenium.webdriver.chrome.options import Options
import json
import urllib.parse
from time import time

options = Options()
options.headless = True
driver = webdriver.Chrome(options=options)

# Access the initial webpage to create the info_dict (including the match_id, and hash)
driver.get('https://www.oddsportal.com/soccer/england/premier-league/liverpool-norwich-4IMoMG3q')
page = driver.page_source
info_dict = json.loads(page.split('var page = new PageEvent(')[-1].split(');')[0])
xhash = urllib.parse.unquote(info_dict['xhash'])
match_id = info_dict['id']

# Access to the feed URL based on the values from the info_dict
driver.get('http://fb.oddsportal.com/feed/match/1-1-{}-1-2-{}.dat?_={}'.format(match_id, xhash, int(round(time()*1000)) + 1000))
print(driver.page_source)

Open in new window


The URL is built up of 3 factors - the match_id, the hash, and epoch time in milliseconds. However, when I try to access this in Selenium, I get the following response:

globals.jsonpCallback('/feed/match/1-1-4IMoMG3q-1-2-yjb3a.dat?_=1562795864899', {'e':'404'})

Open in new window


Would really appreciate any help with this, as I don't really understand where I'm going wrong!
0
Hi Experts,
 We are working on Azure POC for Platform as Service and IAAS. We have created the resources as per the attached architecture.  Now we have to download those resources and working on Infrastructure as code.

I have exported template from Resource group. Now we are planning to create the same environment by this template to another tenant. I have tried to download and deploy template to another tenant but did not work out. Do i need to change any parameter?

Can you please advice me for the steps?

Thank you
Architecture.pptx
ExportedTemplate-Magnificent_8.zip
0
I am using C3.js to show a graph whose data is coming from a URL that is returning JSON formatted data.
Everything works like a charm except when I want to show a simple "No Data Available" when data is empty.

Reading C3 documentation the solution seems to be pretty easy and has to be added within the data array:
empty: {
    label: {
        text: "No Data Available"
    }
},

Open in new window


This is not working "completely" since the text informing of no data available is showing for a fraction of a second and disappear immediately.

I was not able to find any clue showing me a behavior like this.

Just for the records I am using last versions:
 - C3.js 0.7.1
 - D3.js 5.9.2
and of course the related C3.css

Any suggestion?
0
I installed Guzzle and  the Avalara tax client on my machine today and got the attached notices while doing so... is that "hard copies" notice something to be concerned about? It seems like its saying that it took a snapshot of those folders and if I ever change anything in the source folders from now on I need to reinstall, which obviously isn't good.
2019-06-14_13-03-46.jpg
0
MSSQL query to JSON

i have these 2 queries that i need to combine into a single record set then convert to a JSON object, i am afraid i know nothing about how to do this,
   EXEC	[dbo].[YearCompGraph] '2018/01/01', '2018/12/31',2 
   EXEC	[dbo].[YearCompGraph] '2019/01/01', '2019/12/31',2

Open in new window

the stored proc
USE [cmms]
GO
/****** Object:  StoredProcedure [dbo].[YearCompGraph]    Script Date: 11/06/2019 17:45:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:		Duong Ba Hong Minh, minhdbh
-- Create date: 2012/02/12
-- Description:	Insert new tree Node
-- If Parent_ID =0 or null: Node is root
-- =============================================
ALTER PROCEDURE [dbo].[YearCompGraph]
	
	@1stDate date,
	@2ndDate date,
	@eqpID int
AS
BEGIN
	
	SET NOCOUNT ON;
SELECT SUM(CASE datepart(month,ReqDate) WHEN 1 THEN 1 ELSE 0 END) AS 'January',
  SUM(CASE datepart(month,ReqDate) WHEN 2 THEN 1 ELSE 0 END) AS 'February',
  SUM(CASE datepart(month,ReqDate) WHEN 3 THEN 1 ELSE 0 END) AS 'March',
  SUM(CASE datepart(month,ReqDate) WHEN 4 THEN 1 ELSE 0 END) AS 'April',
  SUM(CASE datepart(month,ReqDate) WHEN 5 THEN 1 ELSE 0 END) AS 'May',
  SUM(CASE datepart(month,ReqDate) WHEN 6 THEN 1 ELSE 0 END) AS 'June',
  SUM(CASE datepart(month,ReqDate) WHEN 7 THEN 1 ELSE 0 END) AS 'July',
  SUM(CASE datepart(month,ReqDate) WHEN 8 THEN 1 ELSE 0 END) AS 'August',
  SUM(CASE datepart(month,ReqDate) WHEN 9 THEN 1 ELSE 0 

Open in new window

0

JSON

999

Solutions

910

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.