[Response] section |
The optional [Response] section defines a detailed response for Create, Update, CreateOrUpdate and Delete templates. Each input row will have a corresponding JSON output array element with details describing how your data has been modified.
The [Response] section is a list of TDE columns that you would like in the detail response. A _detail element is also included in every response element to provide diagnostic information.
This section is optional in a template. If you provide one, you will get a detailed response; if not, you will get a summary response.
This topic contains the following sections:
Use the following syntax to get a detailed response
Note |
---|
You can request response fields that you did not include on input to see how your data has been transformed. This is particularly useful for fields that may be modified or generated based on other data. |
Running this template with an input file with two records...
[Template] TemplateVersion = 1.0 TableID = Marker-1.0 TemplateName = Marker Output Response Example Intent = CreateOrUpdate [Output] Id(test) = Input.name Tag = Input.name Lat(Degree) = Input.latitude Lon(Degree) = Input.longitude PrimaryCategoryId(Telogis, Name) = Input.Category [Response] primaryCategoryId PrimaryCategoryId (Telogis, Name) Tag Id Id(test) Lat(Degree) Lon(DDDMMSS) EnvelopeAddress DeliveryDate
would produce a response similar to the following:
[ { "Lat(Degree)": 30, "primaryCategoryId": "123456", "Tag": "marker1", "Id": "100000", "Lon(DDDMMSS)": "0970000.2", "_detail": { "index":0, "operation": "Create", "succeeded": true, "commit": true }, "PrimaryCategoryId(Telogis, Name)": "Customers", "Id(test)": "marker1", "EnvelopeAddress": "654 S Raymond Rd, La Grange, Fayette, Texas, 78945", "DeliveryDate": null }, { "Lat(Degree)": 30, "primaryCategoryId": "123456", "Tag": "marker2", "Id": "100001", "Lon(DDDMMSS)": "0970000", "_detail": { "index":1, "operation": "Update", "succeeded": true, "commit": true }, "PrimaryCategoryId(Telogis, Name)": "Customers", "Id(test)": "marker2", "EnvelopeAddress": "654 S Raymond Rd, La Grange, Fayette, Texas, 78945", "DeliveryDate": null } ]