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/"'80%3BUQAAAAJ7%2F1AARQBUAFQAWQAgAEMAQQBTAEgAAAACe%2F9XAEUAQgAgAFAARQBUAFQAWQAAAACHECcAAAAA10%3B43433144440%3B'"">
<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>