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

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		

Select all Open in new window

…

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"
  }
}

Select all 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
      }
    }
  ]
}'

Select all Open in new window

Just need help to automate this process using Windows, perhaps PowerShell. Any help is greatly appreciated.

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");

Select all 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

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);

Select all 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

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>

Select all Open in new window

Regards

Chris

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 " + 

Select all Open in new window

…

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"

Select all 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?

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

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”,” ”

Select all Open in new window

Kindly help

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'

Select all 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'
    }
}

Select all 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?

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
}
}]
}

Select all Open in new window

Thanks in advance for any help.