Power BI Connector for SugarCRM

Build 20.0.7587

テーブル

本製品 はSugarCRM のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、SugarCRM テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData Power BI Connector for SugarCRM テーブル

Name Description
Accounts Create, update, delete, and query the Accounts module in SugarCRM.
ACLRoles Create, update, delete, and query the ACLRoles module in SugarCRM.
Activities Create, update, delete, and query the Activities module in SugarCRM.
Administration Create, update, delete, and query the Administration module in SugarCRM.
Bugs Create, update, delete, and query the Bugs module in SugarCRM.
Calls Create, update, delete, and query the Calls module in SugarCRM.
CampaignLog Create, update, delete, and query the CampaignLog module in SugarCRM.
Campaigns Create, update, delete, and query the Campaigns module in SugarCRM.
CampaignTrackers Create, update, delete, and query the CampaignTrackers module in SugarCRM.
Cases Create, update, delete, and query the Cases module in SugarCRM.
Comments Create, update, delete, and query the Comments module in SugarCRM.
Contacts Create, update, delete, and query the Contacts module in SugarCRM.
Contracts Create, update, delete, and query the Contracts module in SugarCRM.
ContractTypes Create, update, delete, and query the ContractTypes module in SugarCRM.
Currencies Create, update, delete, and query the Currencies module in SugarCRM.
CustomQueries Create, update, delete, and query the CustomQueries module in SugarCRM.
DataSets Create, update, delete, and query the DataSets module in SugarCRM.
DocumentRevisions Create, update, delete, and query the DocumentRevisions module in SugarCRM.
Documents Create, update, delete, and query the Documents module in SugarCRM.
EAPM Create, update, delete, and query the EAPM (external API module) in SugarCRM.
EmailAddresses Create, update, delete, and query the EmailAddresses module in SugarCRM.
EmailMarketing Create, update, delete, and query the EmailMarketing module in SugarCRM.
Emails Create, update, delete, and query the Emails module in SugarCRM.
EmailTemplates Create, update, delete, and query the EmailTemplates module in SugarCRM.
Employees Create, update, delete, and query the Employees module in SugarCRM.
Filters Create, update, delete, and query the Filters module in SugarCRM.
ForecastManagerWorksheets Create, update, delete, and query the ForecastManagerWorksheets module in SugarCRM.
Forecasts Create, update, delete, and query the Forecasts module in SugarCRM.
ForecastSchedule Create, update, delete, and query the ForecastSchedule module in SugarCRM.
ForecastWorksheets Create, update, delete, and query the ForecastWorksheets module in SugarCRM.
InboundEmail Create, update, delete, and query the InboundEmail module in SugarCRM.
KBDocuments Create, update, delete, and query the KBDocuments module in SugarCRM.
Leads Create, update, delete, and query the Leads module in SugarCRM.
Manufacturers Create, update, delete, and query the Manufacturers module in SugarCRM.
Meetings Create, update, delete, and query the Meetings module in SugarCRM.
Notes Create, update, delete, and query the Notes module in SugarCRM.
Notifications Create, update, delete, and query the Notifications module in SugarCRM.
OAuthKeys Create, update, delete, and query the OAuthKeys module in SugarCRM.
OAuthTokens Create, update, delete, and query the OAuthTokens module in SugarCRM.
Opportunities Create, update, delete, and query the Opportunities module in SugarCRM.
PdfManager Create, update, delete, and query the PdfManager module in SugarCRM.
ProductCategories Create, update, delete, and query the ProductCategories module in SugarCRM.
Products Create, update, delete, and query the Products module in SugarCRM.
ProductTemplates Create, udpate, delete, and query the ProductTemplates module in SugarCRM.
ProductTypes Create, udpate, delete, and query the ProductTypes module in SugarCRM.
Project Create, update, delete, and query the Project module in SugarCRM.
ProjectTask Create, update, delete, and query the ProjectTask module in SugarCRM.
ProspectLists Create, update, delete, and query the ProspectLists module in SugarCRM.
Prospects Create, update, delete, and query the Prospects module in SugarCRM.
Quotas Create, update, delete, and query the Quotas module in SugarCRM.
Quotes Create, update, delete, and query the Quotes module in SugarCRM.
Releases Create, update, delete, and query the Releases module in SugarCRM.
ReportMaker This is a table representing the ReportMaker module in SugarCRM.
Reports This is a table representing the Reports module in SugarCRM.
Reports_1 This is a table representing the Reports module in SugarCRM.
RevenueLineItems This is a table representing the RevenueLineItems module in SugarCRM.
Roles This is a table representing the Roles module in SugarCRM.
SavedSearch This is a table representing the SavedSearch module in SugarCRM.
Schedulers This is a table representing the Schedulers module in SugarCRM.
Shippers This is a table representing the Shippers module in SugarCRM.
Styleguide This is a table representing the Styleguide module in SugarCRM.
Subscriptions This is a table representing the Subscriptions module in SugarCRM.
SugarFavorites This is a table representing the SugarFavorites module in SugarCRM.
Tasks This is a table representing the Tasks module in SugarCRM.
TaxRates This is a table representing the TaxRates module in SugarCRM.
TeamNotices This is a table representing the TeamNotices module in SugarCRM.
Teams This is a table representing the Teams module in SugarCRM.
TimePeriods This is a table representing the TimePeriods module in SugarCRM.
TrackerPerfs This is a table representing the TrackerPerfs module in SugarCRM.
TrackerQueries This is a table representing the TrackerQueries module in SugarCRM.
Trackers This is a table representing the Trackers module in SugarCRM.
TrackerSessions This is a table representing the TrackerSessions module in SugarCRM.
Users This is a table representing the Users module in SugarCRM.
UserSignatures This is a table representing the UserSignatures module in SugarCRM.
WebLogicHooks This is a table representing the WebLogicHooks module in SugarCRM.
WorkFlow This is a table representing the WorkFlow module in SugarCRM.

本製品 は、テーブル に記載されていないSugarCRM アカウントにもカスタムモジュールを公開できます。普通のテーブルと同様に、このカスタムモジュールに対してクエリを実行できます。さらに、標準モジュールのカスタムフィールドをクエリすることができます。

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587