//http://myspsite.com/nrm/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=DIR,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq '402-CSI-001'     //<---  Works when I paste it in the browser
 var projNum = '402-CSI-001';
var endPointUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=DIR,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq "+projNum;  //<---  Not valid when I run it in my code

Select all Open in new window

function loadSPItems() {
var projNum = '402-CSI-001';
var endPointUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbyTitle('My_Project_Modules')/items?$select=VISN,Station,Title,Building_x0020_Number&$filter=Project_x0020_Number eq "+projNum;//,ProjectNumber,ApprovalStatus,ProjectExecutionStatus”;
var headers = { 
	"accept": "application/json;odata=verbose" 
}
 
jQuery.ajax({ 
	url: endPointUrl, 
	type: "GET", 
	headers: headers, 
success: function (data) {
	console.dir(data);
}, 
	error: function (err) { 
	alert("Error Occured:" + JSON.stringify(err)); 
}
 
});
 
}

loadSPItems();

Select all Open in new window

{
"-KkKsqJ9VyBILEg-DOPX": {
"direction": "SSE",
"email": "anita@gmail.com",
"site": "Bridges",
"speed": "5-10",
"status": "Flyable",
"statusDescription": "Epic"
},
"-KkKvkBn_kAR0YB1hIX_": {
"direction": "E",
"email": "joe@gmail.com",
"site": "Moirs",
"speed": "10-15",
"status": "Flyable",
"statusDescription": "Its OK"
}
}

Select all Open in new window

<table id="displayData">
  <tr>
    <td>Direction</td>
    <td><email/td>
    <td>Site</td>
    <td>Speed</td>
    <td>Status</td>
    <td>StatusDescription</td>
  </tr>
</table>

Select all Open in new window

<div id = "display"></div>

Select all Open in new window

//reference table and div
const firedata = document.getElementById('displayData');
const display = document.getElementById('display');

//create reference
const dbRefObject = firebase.database().ref().child('posts' );

//sync changes
dbRefObject.on('value', snap => {
  
//Display data in an HTML Table
//????????????

//display JSON in a div - works ok, returns the JSON above
  display.innerText = JSON.stringify(snap.val(), null, 3);

//display in console - works ok
  console.log(snap.val()); 
});

Select all Open in new window

An unhandled exception of type 'Newtonsoft.Json.JsonSerializationException' occurred in Newtonsoft.Json.dll

Additional information: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[SpringAhead.Timecard]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.

To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.

Path '?xml', line 1, position 8.

Select all Open in new window

Imports System.Xml.Serialization
''' <remarks/>
<System.CodeDom.Compiler.GeneratedCodeAttribute("xsd", "4.6.1055.0")>
<System.SerializableAttribute>
<System.Diagnostics.DebuggerStepThroughAttribute>
<System.ComponentModel.DesignerCategoryAttribute("code")>
<System.Xml.Serialization.XmlRootAttribute([Namespace]:="", IsNullable:=True)>
Partial Public Class SA

    Private timecardField As Timecard()

    ''' <remarks/>
    <System.Xml.Serialization.XmlElementAttribute("Timecard", IsNullable:=True)>
    Public Property Timecard() As Timecard()
  

Select all Open in new window

package main

import (
	"fmt"
	"encoding/json"
	"io/ioutil"
)

func main() {

	b, _ := ioutil.ReadFile("/home/david/jsontest/create.jsontest.campaigns.ninja.json")

	type UserData struct {
		user_id    string
		user_email string
		user_name  string
	}

	type campaign struct {
		domain      string
		Ssl         int64
		server_key  string
		certificate string
		bundle      string
		php_ver     string
		wp          int64
		lang        string
		start_date  string
		end_date    string
		description string
		user_data   UserData
		CampaignID  int64
	}

	var m campaign
	err := json.Unmarshal(b, &m)
	if err != nil {
		panic (err)
	}
	fmt.Printf("%d", m.CampaignID)
	fmt.Printf("%s",m.user_data.user_email)
}

Select all Open in new window

/usr/lib/golang/bin/go run /home/david/GoglandProjects/CampaignsNinja/jsontest.go
80099700
Process finished with exit code 0

{"domain":"jsontest.campaigns.ninja","ssl":1,"server_key":"","certificate":"","bundle":"","php_ver":"5.6","wp":1,"lang":"english","start_date":"2017-02-02","end_date":"2017-03-02","description":"This is a test","user_data":{"user_id":"74","user_email":"usertest@gmail.com","user_name":"usertest"},"CampaignID":80099700}

deleteSelectedNode() { 
    //Get the node which was selected by the user  
    let nodeToDelete: TreeNode = this.myService.getActiveNode();
    //id will be unique, can be used to identify the node
    let idToDelete = nodeToDelete.data.id; 
    this.traverseTree(this.nodes[0], idToDelete);
  }

  traverseTree(obj, idToDelete: string) {

    for (var k in obj) {
      if (typeof obj[k] == "object" && obj[k] !== null) {
        this.traverseTree(obj[k], idToDelete);
      }

      else {
        if (k === 'id') 

Select all Open in new window