@Parvesh_Parmar Im attempting to replicate this for customer loyalty anniversary date, which is a date time field. When running the query, it doesn't return anyone.SELECT *FROM table_nameWHERE TO_CHAR(AppSignupDatetime, 'MM-DD') = TO_CHAR(CURRENT_DATE, 'MM-DD'); Since the field is a date time field,...

@DavidRoss91 something like this for example {"_object": {"LID": "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx","AsOf": "2024-11-05","rfCategory": "Loyal","rfMonetaryCategory": "Other"},"_id":"2024-11-05Loyalxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxOther","eventType":"rfm.status.update","timestamp":"2024-11-05T00:00:0...

@DavidRoss91 do you know if the HTTP API Source Connector is able to handle an array in the ingestion payload? When I test this using postman I am able to successfully ingest a record, but when pushing a large payload from Databricks, im getting ingestion errors about _id being missing.

Hello all, I am trying to validate incoming source data into the HTTP API Source Connector in Adobe CDP and getting some errors I have been unable to resolve.  My initial question is: If I am trying to ingest this data as an event into Adobe CDP, does my source file JSON need to include _id and time...

Thank you again for your assistance @Parvesh_Parmar 

Im curious if its possible to aggregate by week in audience builder. For example, I want to create an audience of customers who complete 2 purchases in different weeks in the past 8 weeks.   Below is an example, but I think this format will become an issue when looking at customers who completed 3-5...

Thank you so much @Parvesh_Parmar option 1 seems to work for this use case.

Hi @Parvesh_Parmar thank you for this! Im having an issue getting the correct syntax as I am having to convert the timestamp from a string to date time using the following function:date(DateTimeSend,"M/d/yyyy h:mm:ss a",now()) This is the new function I am attempting:zone_date_to_utc(date(DateTimeSe...

Hey there,  Im noticing that my timestamp for a mobile push opened event in AEP is an hour ahead. (Should be 11:25 am but is showing 12:25pm). In SFMC, I am performing a mobile push data extract to extract the previous days mobile push engagement to send to AEP. The timezone selected for the data ex...

Thank you @Parvesh_Parmar  this is exactly what I needed!