Web API to Update Data of DB

aloks0189

Certified Lead Developer

over 7 years ago

Hi,
I have a requirement where i need to Update the data of the Database using Web-API, for that i created a Web API using POST method having a!writeToDataStoreEntity() function configured.

Problem Statement:- when i pass the JSON Format data into body field of Web API, it works Well, but whenever i am trying to do the same using an Expression rule where i have defined a rule input of type text where specified value is the same JSON which i used earlier, then nothing gets Update in database and also no log informations about it, and it returns Writer Type followed by following Value
[name=httpwriter_appian_internal, parameters=http://localhost:port/suite/webapi/storeEmployee; POST; ; ; [username=[externalSystemKey=mycredentials, fieldKey=username, usePerUser=false], password=[externalSystemKey=mycredentials, fieldKey=password, usePerUser=false], preemptive=true];followed by Data
...

Discussion posts and replies are publicly visible

Parents

0 aloks0189
Certified Lead Developer
over 7 years ago

@stefanh791 thanks for your suggestions, i separated httpWrite() into a expression rule, and invoked bind() from saveInto on a SAIL, and also one more problem which i identified was if we convert CDT to Json using toJson() function because in Web API i used fromJson() that means expecting the data to come in JSON Fromat Only, and if CDT Contains Date Field then it used to get convert into 'yyyy-mm-dd' format which is an Invalid Appian Date format, and hence it was raising an error, so i created a Plugin which can modify the Json Data and convert respective given Date Property values to Respective Our Specified (Appian Format) and will return the Complete Valid JSON Text data, which i pushed into httpWrite body, and my problem is got resolved. I will try to share that Plugin to Forum

Thanks for Your Support
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aloks0189
Certified Lead Developer
over 7 years ago

@stefanh791 thanks for your suggestions, i separated httpWrite() into a expression rule, and invoked bind() from saveInto on a SAIL, and also one more problem which i identified was if we convert CDT to Json using toJson() function because in Web API i used fromJson() that means expecting the data to come in JSON Fromat Only, and if CDT Contains Date Field then it used to get convert into 'yyyy-mm-dd' format which is an Invalid Appian Date format, and hence it was raising an error, so i created a Plugin which can modify the Json Data and convert respective given Date Property values to Respective Our Specified (Appian Format) and will return the Complete Valid JSON Text data, which i pushed into httpWrite body, and my problem is got resolved. I will try to share that Plugin to Forum

Thanks for Your Support
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data