REST based WEB Service. Using the Note field Correctly.

Hi Everyone,


Here is a tutorial on how to set/update the note field for records.

Setting a note value
To set a note value by the contract-based REST API, do the following:

1. Retrieve the record in question
1. Set your contract-based REST API request with the following settings:
• HTTP method: GET
• URL: https://<entity>/Default/<endpoint version>/<endpoint name>/<record name>
• No parameters for request
• Headers:
• Accept -> application/json
• Content-Type -> application/json
2. Send the request. The response contains 200 OK status. The body of the response includes the list of fields of the record in JSON format. The following is an example
{
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",
"rowNumber":1,
"note":"",
"CountNbr":{
"value":"FCN000021"
},
"Details":[...],
"custom":{},
"files":[]
}
2. Save the request
3. Update the note field
1. Set your contract-based REST API request with the following settings:
• HTTP method: PUT
• URL: https://<entity>/Default/<endpoint version>/<endpoint name>/<top-level record name>
• No parameters for request
• Headers:
• Accept -> application/json
• Content-Type -> application/json
• Body of the request (where NOTECONTENT should be the note):
{
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",
"note":"NOTECONTENT",
}
OR
{
"CountNbr":{
"value":"FCN000021"
},
"note":"NOTECONTENT",
}
2. Send the request. If the request is successful, the response contains the 200 OK status code and includes the list of updated records in JSON format. The following is an example
{
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",
"rowNumber":1,
"note":"NOTECONTENT",
"CountNbr":{
"value":"FCN000021"
},
"Details":[...],
"custom":{},
"files":[]
}

Important information to remember

• Make sure to always specify the note parameter to the note value, even when it is not being changed, as otherwise the note will be set to a empty string. This goes for all PUT requests

Adding Links to Notification Emails

Hi Everyone,

There is sometimes a task to add dynamic or static links to system generated Notifications.
Here is how to do it.

1. Add a field to a screen, where your dynamic link will be generated and stored.

Adding URL Filed

2. Create a notification Template adding there a link with the content from the field above:

Referencing a link in the Notification

As a result your notification will get the Link from the field.

Notification Template with the Link added

All the best,
Sergey.

The Learning Lab - Acumatica Customer of the Year

Dear Reader!

I am Proud to announce:

The biggest Private Primary and Secondary Learning Provider in Singapore - The Learning Lab just achieved the Customer of the Year award at Acumatica Asia Roadshow 2018 !

Together with Info Cloud Asia - leading consulting firm in Singapore, TLL achieved flawless implementation and integrated Acumatica with the CRM front end, Attendance Tracking Security system as well as Claim Tracking.

Congratulations - it was an example of great team work!

All the best!

Date Conversion Formats. TSQL.

Hi Everyone,

Hope this conversion table will help to present date and time in proper way.

For example if you wish to see the current date, in MM/DD/YY please use 1 as a format:

Statement:

SELECT CONVERT(varchar(120),GETDATE(),1)

Will return you 12/28/17

In general, using SELECT CONVERT(varchar(120),GETDATE(),FORMAT)

Where FORMAT is just a number from the list will provide you respective output:

output                   style
Apr 28 2014  9:31AM          0
04/28/14                     1
14.04.28                     2
28/04/14                     3
28.04.14                     4
28-04-14                     5
28 Apr 14                    6
Apr 28, 14                   7
09:31:28                     8
Apr 28 2014  9:31:28:580AM   9
04-28-14                     10
14/04/28                     11
140428                       12
28 Apr 2014 09:31:28:580     13
09:31:28:580                 14
2014-04-28 09:31:28          20
2014-04-28 09:31:28.580      21
04/28/14  9:31:28 AM         22
2014-04-28                   23
09:31:28                     24
2014-04-28 09:31:28.580      25
Apr 28 2014  9:31AM          100
04/28/2014                   101
2014.04.28                   102
28/04/2014                   103
28.04.2014                   104
28-04-2014                   105
28 Apr 2014                  106
Apr 28, 2014                 107
09:31:28                     108
Apr 28 2014  9:31:28:580AM   109
04-28-2014                   110
2014/04/28                   111
20140428                     112
28 Apr 2014 09:31:28:580     113
09:31:28:580                 114
2014-04-28 09:31:28          120
2014-04-28 09:31:28.580      121
2014-04-28T09:31:28.580      126
2014-04-28T09:31:28.580      127
28 جمادى الثانية 1435  9:31:28:580AM    130
28/06/1435  9:31:28:580AM    131

All the best,
Sergey.