We have custom action configured where we are passing certain fields. The requirement is to send the field as 'null' where we don't have the data. We used the below functionality of AJO to set the value as null but the problem is AJO does not send this field name itself in the REST call if the value...

You Can set it like this in the custom Type of wait expression   toDateTimeOnly(setHours(nowWithDelta(1,"days"),9))  

Thanks @Anuhya-Y. The structure worked.

I am partially able to update objects that are 1 level below the tenant but still 2nd level nested objects unable to update as well as individual fields under the objects. Here is the working query for objects update except for nested 'address' object   INSERT INTO final_dataset select struct ( Prof...

Not sure why but always get a job aborted error when I try nested struct. ErrorCode: 58000 Batch query execution gets : [failed reason ErrorCode: 58000 Batch query execution gets : [Failed to get results of query Reason: [Job aborted.]]]

Not working as dot(.) not allowed while defining struct ( "_Tenant.customerID"). Error : Column names can only contain alphanumeric or underscore characters]]]

I tried this already but it did not work. Receiving the error in QS " [Errors(Some(INGEST-1207-400),Some(List()),Some(A required field _Tenant.Identity of type: object is missing from the input data. Add the required field and try again.))]"   At the dataset level. I see the below errors. A required...

I need to work on a query that will fetch results of join between two temp datasets that are not profile enabled then use that resultset to insert into profile enabled dataset. There is minimal mention in the documentation which doesn't show nested objects.    E.g. Query I tried below did not work P...

Yes but this workaround is only for a particular use-case & can not be used as a foolproof solution.

We want to personalize timeseries attributes in a Marketing campaign. The above will work only in case of events I believe.