Creating a formula date/time field through the REST API

Question

Hello,i seem to be having an issue regarding creating a formula date/time field using the REST API.i get the field data from a different table and receive something like this

&nbsp;{
&nbsp; &nbsp; &nbsp; &nbsp; "appearsByDefault": false,
&nbsp; &nbsp; &nbsp; &nbsp; "audited": false,
&nbsp; &nbsp; &nbsp; &nbsp; "bold": false,
&nbsp; &nbsp; &nbsp; &nbsp; "doesDataCopy": false,
&nbsp; &nbsp; &nbsp; &nbsp; "fieldHelp": "",
&nbsp; &nbsp; &nbsp; &nbsp; "fieldType": "timestamp",
&nbsp; &nbsp; &nbsp; &nbsp; "findEnabled": false,
&nbsp; &nbsp; &nbsp; &nbsp; "id": 415,
&nbsp; &nbsp; &nbsp; &nbsp; "label": "Week Ending Date",
&nbsp; &nbsp; &nbsp; &nbsp; "mode": "formula",
&nbsp; &nbsp; &nbsp; &nbsp; "noWrap": true,
&nbsp; &nbsp; &nbsp; &nbsp; "properties": {
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "allowNewChoices": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "carryChoices": true,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "defaultToday": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "defaultValue": "",
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayDayOfWeek": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayMonth": "number",
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayRelative": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayTime": true,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "displayTimezone": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "foreignKey": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "formula": "If(DayOfWeek(ToDate([Date Created])) = 5 , [Date Created]",
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "primaryKey": false,
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "sortAsGiven": false
&nbsp; &nbsp; &nbsp; &nbsp; }

i then plug these in to create a new field in another app

{'label': fieldpull['label'], 
'fieldType': fieldpull['fieldType'], 
'properties': 
 {"formula": fieldpull['properties']["formula"]}}

but whenever my python script encounters a date-time formula field, it gives me this error{'message': 'Bad Request', 'description': '[formula] property is not supported'}does anyone know how to get around this error?

tylerbrezler · Answer

Although the API returns a response that shows the field type as "timestamp", that's actually not a specifiable field type when creating a field. Yes, this is confusing.

You must specify the field type "datetime" in order for the request to work. Guess you'll probably have to create a condition to convert timestamp to datetime.

Forum Discussion

Creating a formula date/time field through the REST API