Dynamics Community Forum Thread Details

I have project to create new entries in Microsoft Navision 2017 with ODATA JSON web service by PHP

I found below link and trying to use it in my scenario but getting error null

Link i have used to start

Creating new entities from PHP using the Microsoft Dynamics NAV 2016's Odata web services

my code is

<?php

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, "xxxxxx/OData/Company('Company')/ExpenseEntries");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode ([

    'Journal_Template_Name'=> 'PETTY CASH',
    'Journal_Batch_Name'=> 'WEB PETTY',
    'Line_No'=> 20000,
    'Posting_Date'=> '2020-06-23T00:00:00',
    'Document_Type'=> 'Payment',
    'Document_No'=> 'PC000040',
    'Account_Type'=> 'G/L Account',
    'Account_No'=> '522020',
    'Description'=> 'STAFF FOOD EXPENSES',
    'Debit_Amount'=> '50',
    'Credit_Amount'=> '0',
    'Shortcut_Dimension_1_Code'=> '1001',
    'Shortcut_Dimension_2_Code'=> '3002'

]));

curl_setopt($ch, CURLOPT_USERPWD, 'ABC:DCE');
curl_setopt($ch, CURLOPT_HTTPHEADER, [
        'Connection: Keep-Alive',
        'Accept: application/json',
        'Content-Type: application/json; charset=utf-8',
        "Accept: */*"
]);

$response = json_decode(curl_exec($ch), TRUE);

echo json_encode($response, JSON_PRETTY_PRINT);

// Close handle
curl_close($ch);

 ?>



When I enter web api in web browser and enter user and password, below xml result i am getting which might be help in advice, one entry i have created mannually in navision application. now struggling to make enrty with PHP

<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="">xxxxx/.../"
    xmlns="">http://www.w3.org/2005/Atom"
    xmlns:d="">schemas.microsoft.com/.../dataservices"
    xmlns:m="">schemas.microsoft.com/.../metadata">
    <id>xxxxx/.../PettyCashWebAPI</id>
    <title type="text">PettyCashWebAPI</title>
    <updated>2020-06-23T19:39:39Z</updated>
    <link rel="self" title="PettyCashWebAPI" href="PettyCashWebAPI" />
    <entry m:etag="W/&quot;'80%3BUQAAAAJ7%2F1AARQBUAFQAWQAgAEMAQQBTAEgAAAACe%2F9XAEUAQgAgAFAARQBUAFQAWQAAAACHECcAAAAA10%3B43433144440%3B'&quot;">
        <id>xxxx/.../PettyCashWebAPI(Journal_Batch_Name='WEB PETTY',Journal_Template_Name='PETTY CASH',Line_No=10000)</id>
        <category term="NAV.PettyCashWebAPI" scheme="">schemas.microsoft.com/.../scheme" />
        <link rel="edit" title="PettyCashWebAPI" href="Company('Company')/PettyCashWebAPI(Journal_Batch_Name='WEB%20PETTY',Journal_Template_Name='PETTY%20CASH',Line_No=10000)" />
        <title />
        <updated>2020-06-23T19:39:39Z</updated>
        <author>
            <name />
        </author>
        <content type="application/xml">
            <m:properties>
                <d:Journal_Template_Name>PETTY CASH</d:Journal_Template_Name>
                <d:Journal_Batch_Name>WEB PETTY</d:Journal_Batch_Name>
                <d:Line_No m:type="Edm.Int32">10000</d:Line_No>
                <d:Posting_Date m:type="Edm.DateTime">2020-06-23T00:00:00</d:Posting_Date>
                <d:Document_Type>Payment</d:Document_Type>
                <d:Document_No>PC000039</d:Document_No>
                <d:Account_Type>G/L Account</d:Account_Type>
                <d:Account_No>441015</d:Account_No>
                <d:Description>CASH SALES (BAIZA DIFF)</d:Description>
                <d:Debit_Amount m:type="Edm.Decimal">100</d:Debit_Amount>
                <d:Credit_Amount m:type="Edm.Decimal">0</d:Credit_Amount>
                <d:Shortcut_Dimension_1_Code>1001</d:Shortcut_Dimension_1_Code>
                <d:Shortcut_Dimension_2_Code>3002</d:Shortcut_Dimension_2_Code>
                <d:ETag>80;UQAAAAJ7/1AARQBUAFQAWQAgAEMAQQBTAEgAAAACe/9XAEUAQgAgAFAARQBUAFQAWQAAAACHECcAAAAA10;43433144440;</d:ETag>
            </m:properties>
        </content>
    </entry>
</feed>