Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
5 subscribers
Views
3442 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
WebAPI: a!fromJson() - Date issue
nagapriyar1
over 8 years ago
While calling a!fromJson() method in WebAPI, the Date and time attribute is populated as Date out of range (2147483647).
When I pass date format as "Feb 20, 2017 1:30:00 PM" in request body I confront issues, but while passing date format as “20/02/2017 1:30 PM” it works.
Code snippet:
with(
a!startProcess(
processModel: cons!SampleModel,
processParameters:
'type!{urn:com:appian:types}Employee'(action:"Update",Employee:a!fromJson(http!request.body).Employee)
/*a!fromJson(
http!request.body
)*/,
onSuccess: a!httpResponse(
statusCode: 200,
headers: {
a!httpHeader(name: "Content-Type", value: "application/json")
},
body: a!toJson(
index(fv!ProcessInfo,"pv", {}).Employee
)
),
onError: a!httpResponse(
statusCode: 500,
headers: {
a!httpHeader(name: "Content-Type", value: "application/json")
},
...
OriginalPostID-261414
Discussion posts and replies are publicly visible
0
nagapriyar1
over 8 years ago
... body: a!toJson(
{
error: "There was an error starting the process"
}
)
)
)
)
=============================Request body=========
{"action":"Update",
"Employee":{
"id": null,
"entityDetail": {
"datalessKey": 1686401,
"shortName": "INDEPENDENT OIL",
"altId": "11P999",
"entityType": "BUS_ENT",
"dataLessKeyText": "1686401"
},
"categoryDetail": {
"categoryId": null,
"categoryName": "BUSINESS_ENTITY",
"subjectArea": "INSTRUMENT_BUSINESS_ENT",
"appianProcessId": 537014155,
"owner": "bragadeesh.perumal.swamy@fmr.com",
"claimDate": "Nov 7, 2016 1:30:00 PM",
"status": "ONPREM",
"deferral_DateTime": "Feb 20, 2017 1:30:00 PM",
"SLA": 480,
"autoDeferFlag": false,
"environment": "fmrcoappian.sit"
},
"violationList": [
{
"id": 1,
"categoryId": null,
"violationType": "UNKNOWN_KINGLAND:697373657232",
"attributeKeyList": [
{
...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nagapriyar1
over 8 years ago
... "violationId": 1,
"keyName": "MDY",
"keyValue": "VALUE"
}
],
"attributeKeyString": "VALUE ",
"attributeValue": null,
"resolvedFlag": false,
"vendorSuppliedValue": null,
"source": "KINGLAND",
"resolvedBy": "",
"note": "Entity does not exist in the FMR universe. CHILD KINS ID: 697373667356, Link Percentage: 49.71, PARENT:\\u003d KINS ID: 697373657232, Entity Name: INCREASED OIL RECOVERY AS",
"openDate": "Sep 12, 2016 2:30:00 PM",
"lastUpdateDate": "Nov 3, 2016 2:30:00 PM",
"resolutionDate": null
}
]
}}
==========================Response=====================
Date attribute populated as
"deferral_DateTime" : "246413671-02-25T00:00:00.000+0000",
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
@nagapriyar whenever you get a date value in form of JSON then the format of the Data gets Change, hence there is a shared component named as Date Formatter in JSON which can convert the date value to any specified format,
For details, please follow this Link:
forum.appian.com/.../e-257592
Hope this will help you
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 8 years ago
As we know the Appian Date Format is mm/dd/yyyy , when you look into the data which come from a!fromJson() function, will be of different format, hence try following the above mention URL
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel