User Manual

08.14.2024

MANUAL

FAQ: I want to set a date item to NULL in the API

## Answer Please set a value outside the range of the values ​​set in the "MinTime" and "MaxTime" parameters of the "[General.json](/ja/manual/general.json)". --- ## Overview You can update the date field to NULL by setting a value outside the range of the values ​​set in "MinTime" and "MaxTime" of "[General.json](/ja/manual/general.json)" in the "Record Update" of Pleasanter "[API](/ja/manual/api)". ## Script This is a script that updates date A to NULL. If "MinTime" and "MaxTime" of "[General.json](/ja/manual/general.json)" are set as follows, it will set to "1899/12/31". MinTime: "1900/1/1" MaxTime: "2100/1/1" ##### javascript ``` $p.apiUpdate({ id: 123456, data: { ApiVersion: 1.1, DateHash: { DateA: '1899/12/31' } }, done: function (data) { console.log('success!'); console.log(data); }, fail: function (data) { console.log('fail...'); console.log(data); } }); ``` ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/general.json">パラメータ設定:General.json</a><span>06.12.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/api">Developer Function: API</a><span>08.14.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/extended-sql-api">Developer Function: Extensions: Extended SQL: Executing Extended SQL from the API</a><span>08.14.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/faq-api-paging">FAQ: I want to retrieve data exceeding 200 records via API</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/faq-api">FAQ: An error occurs when executing the API</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/faq-json-format">FAQ: What to check if modified configuration files or API requests (JSON format) are not recognized correctly</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.