0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

CRMAのデータ同期検索条件の設定 Sample of Filter Local Data Synced to CRM Analytics

Last updated at Posted at 2024-06-05

When you sync Salesforce objects to CRMA, you can filter the data to be synced. Otherwise, if you have too many records, the sync will take a long time and consume a significant amount of CRMA storage.

Here, I am going to share some commonly used samples.

SalesforceオブジェクトをCRMAに同期する際、同期するデータをフィルターすることができます。そうしないと、レコードが多すぎる場合、同期に時間がかかり、CRMAのストレージを大量に消費することになります。

ここでは、よく使用されるサンプルをいくつか紹介します。

  1. Only sync the record which has been created after some day.
    特定日付以降のデータの取得:
       
    CreatedDate > 2024-01-01T00:00:00Z

image.png

  1. Data has been created in recent one year
    最近一年間のデータの取得
    CreatedDate >= LAST_N_DAYS:365

image.png

  1. 複数条件を利用する場合 /Multiple conditions
    例:作成日が2024年6月1日以降 及び 業種=農業

image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?