Ragic Logo
<< Creating a New EntryTable of ContentsCreate / Update Parameters >>

Modifying an Entry

The endpoint for modifying an entry is also the same as reading an existing entry.

https://www.ragic.com/<account>/<dbUrl>/<formNumber>[/<id>]?api

All you need to provide is the field ids of the fields that you would like to modify to. If the field is a date field the value will need to be in the format of yyyy/MM/dd or yyyy/MM/dd HH:mm:ss if there's a time part.

curl -F '800003=Dwight Schrute' \

-F '800007=Partner' \

-F 'api=' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

https://www.ragic.com/demo/sales/1/3

For subtables, it's a bit more tricky. Because Ragic will need to know which row that you're editing. So you will need to find the row id of the row that you're editing. This information can be also found from an API call.

As we mentioned in earlier chapter, the returned format for an entry with subtables look like this:

"14": {

"Account Name": "Ratshotel",

"Account Owner": "Dwight Schrute",

"Phone": "1-267-922-5529",

...

"_subtable_800014": {

"29": {

"Contact Name": "Arden Jacobs",

"Title": "Specialist",

"E-mail": "Arden@ratshotel.com",

},

"30": {

"Contact Name": "Kermit Moore",

"Title": "Manager",

"E-mail": "Kermit@ratshotel.com",

}

}

}

In the subtable, 29 is the row id for the contact Arden Jacobs, and 30 is the row id for the contact Kermit Moore. With this row id, you can modify data in the subtable pretty much like how you create an entry with subtable data.

You use the row id as the identifier following the field id. You only need to put in the fields that you want to modify:

1000015_29=Senior Specialist

1000016_29=arden2@ratshotel.com

1000015_30=Senior Manager

The whole request would be like this:

curl -F '800003=Dwight Schrute' \

-F '800007=Partner' \

-F '1000015_29=Senior Specialist' \

-F '1000016_29=arden2@ratshotel.com' \

-F '1000015_30=Senior Manager' \

-F 'api=' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

https://www.ragic.com/demo/sales/1/3

If you want to delete a subtable row, you can create a request like:

DELSUB_<subtable key>=<subtable row id>

For example, if you want to delete the contact Arden Jacobs, the whole request would be like this:

curl -F 'DELSUB_800014=29' \

-F 'api=' \

-H "Authorization:Basic YOUR_API_KEY_GOES_HERE" \

https://www.ragic.com/demo/sales/1/3

Top of Page
<< Creating a New EntryTable of ContentsCreate / Update Parameters >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy