All articles

  1. ABS

  2. ACOS

  3. AddDuration

  4. Allow Xplenty access to my data on Azure Blob Storage

  5. Allow Xplenty access to my data on Google Cloud Storage

  6. Allow Xplenty access to my Google Cloud Spanner instance

  7. Allow Xplenty access your data on Salesforce

  8. Allowing Xplenty access to Azure SQL Databases

  9. Allowing Xplenty access to data on Amazon S3

  10. Allowing Xplenty access to Facebook Ads Insights data

  11. Allowing Xplenty access to MongoDB

  12. Allowing Xplenty access to my Amazon Athena instance

  13. Allowing Xplenty access to my data on Bing Ads

  14. Allowing Xplenty access to my data on Google AdWords

  15. Allowing Xplenty access to my data on Google Analytics

  16. Allowing Xplenty access to my data on Google Sheets

  17. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)

  18. Allowing Xplenty access to my data on Instagram

  19. Allowing Xplenty access to my data on Intercom

  20. Allowing Xplenty access to my data on Linkedin

  21. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)

  22. Allowing Xplenty access to my data on Shopify

  23. Allowing Xplenty access to my data on Xero

  24. Allowing Xplenty access to my data on Xero

  25. Allowing Xplenty access to my data on YouTube

  26. Allowing Xplenty access to my Google BigQuery dataset

  27. Allowing Xplenty access to my Redshift cluster

  28. Allowing Xplenty access to my server behind a firewall

  29. Allowing Xplenty access to my Snowflake account

  30. Allowing Xplenty access to NetSuite

  31. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS

  32. API Endpoints with pagination support

  33. ASIN

  34. ATAN

  35. BagToString

  36. BagToTuple

  37. Base64Decode

  38. Base64DecodeToString

  39. Base64Encode

  40. Base64EncodeToString

  41. BinaryCCurl

  42. BinaryCurl

  43. BrowserFamily

  44. BrowserFullName

  45. BrowserMajor

  46. BrowserMinor

  47. BrowserPatch

  48. BrowserVersion

  49. ByteArrayToString

  50. CBRT

  51. CCurl

  52. CCurlPoll

  53. CCurlWithPagination

  54. CEIL

  55. Changing your password

  56. CityNameFromIP

  57. ClockTime

  58. COALESCE

  59. CONCAT

  60. ContinentCodeFromIP

  61. ContinentNameFromIP

  62. COS

  63. COSH

  64. CountryCodeFromIP

  65. CountryNameFromIP

  66. Create a package from a template

  67. Creating a cluster

  68. Creating a new package

  69. Creating a new package in New Xplenty

  70. Creating a workflow

  71. CSVSPLIT

  72. Curl

  73. CurlPoll

  74. CurlWithPagination

  75. CurrentTime

  76. DateDiffDays

  77. DateDiffHours

  78. DateDiffMinutes

  79. DateDiffMonths

  80. DateDiffSeconds

  81. DateDiffYears

  82. DaysBetween

  83. Defining connections

  84. DeviceFamily

  85. DistInMilesHaversine

  86. Editing and scaling clusters

  87. Email Hooks

  88. ExecuteBQInsert

  89. ExecuteSqlBoolean

  90. ExecuteSqlDateTime

  91. ExecuteSqlDouble

  92. ExecuteSqlFloat

  93. ExecuteSqlInt

  94. ExecuteSqlLong

  95. ExecuteSqlNonQuery

  96. ExecuteSqlString

  97. EXP

  98. ExtractQueryStringParam

  99. ExtractSearchQuery

  100. ExtractUABrowserID

  101. ExtractUABrowserName

  102. ExtractUrlPart

  103. Flatten

  104. FLOOR

  105. GetBytes

  106. GetDay

  107. GetHour

  108. GetMilliSecond

  109. GetMinute

  110. GetMonth

  111. GetSecond

  112. Getting Started

  113. GetWeek

  114. GetWeekYear

  115. GetYear

  116. HipChat Hooks

  117. HoursBetween

  118. How Do I Move data incrementally between databases

  119. How Do I Process JSON data

  120. How Do I Read data from file storage incrementally

  121. How do I select my file input format

  122. How Do I Work with Datetime Data

  123. How to create a delivery

  124. Importing Heroku Connections

  125. INDEXOF

  126. IntervalIntersection

  127. IsBase64

  128. IsEmpty

  129. IsISODatetime

  130. ISOAddDuration

  131. ISODatetimeToString

  132. ISODatetimeToTimestampFormat

  133. ISOSubtractDuration

  134. ISOToDay

  135. ISOToHour

  136. ISOToMinute

  137. ISOToMonth

  138. ISOToSecond

  139. ISOToWeek

  140. ISOToYear

  141. JsonExtract

  142. JsonExtractScalar

  143. JsonStringToBag

  144. JsonStringToMap

  145. LAST_INDEX_OF

  146. LatitudeFromIP

  147. LCFIRST

  148. Length

  149. List of Salesforce objects

  150. LOG

  151. LOG10

  152. LongitudeFromIP

  153. LOWER

  154. Managing your account settings

  155. Managing your SSH keys

  156. Managing your Xplenty account members

  157. MapToBag

  158. MapToQueryString

  159. MD2

  160. MD5

  161. MilliSecondsBetween

  162. MinutesBetween

  163. Modifying your personal settings

  164. Monitoring clusters

  165. Monitoring jobs

  166. MonthsBetween

  167. OsFamily

  168. OsFullName

  169. OsMajor

  170. OsMinor

  171. OsPatch

  172. OsPatchMinor

  173. OsVersion

  174. PagerDuty Hooks

  175. ParseDate

  176. ParseDoubleOrDefault

  177. ParseFloatOrDefault

  178. ParseIntOrDefault

  179. ParseLongOrDefault

  180. PlatformFamily

  181. POW

  182. QueryStringToMap

  183. RANDOM

  184. REGEX_EXTRACT

  185. REGEX_EXTRACT_ALL

  186. REGEX_FIND_ALL

  187. RegionCodeFromIP

  188. RegionNameFromIP

  189. REPLACE

  190. Reverse

  191. ROUND

  192. ROUND_TO

  193. Running jobs

  194. Scheduling Package Execution

  195. SecondsBetween

  196. Selecting a plan

  197. Selecting the account to work in

  198. Service Hooks

  199. Set up a reverse SSH tunnel from Windows

  200. Setting account member roles

  201. SHA1

  202. SHA256

  203. SHA256WithRSA

  204. SHA384

  205. SHA512

  206. Signing out from Xplenty

  207. SIN

  208. SINH

  209. SIZE

  210. Slack Hooks

  211. Sleep

  212. SPRINTF

  213. SQRT

  214. StringToISODatetime

  215. STRSPLIT

  216. STRSPLITTOBAG

  217. SUBSTRING

  218. SubtractDuration

  219. SwitchTimeZone

  220. System and pre-defined variables

  221. TAN

  222. TANH

  223. Terminating a cluster

  224. TimestampFormatToISODatetime

  225. To view job progress details

  226. TOBAG

  227. ToDate

  228. ToDateCustomFormats

  229. ToHexString

  230. ToJson

  231. TOKENIZE

  232. TOMAP

  233. ToMilliSeconds

  234. ToString

  235. TOTUPLE

  236. ToUnixTime

  237. TRIM

  238. UCFIRST

  239. UPPER

  240. URLDecode

  241. URLEncode

  242. Using and setting variables in your packages

  243. Using components: Aggregate

  244. Using components: Aggregate Transformation

  245. Using components: Amazon Redshift Destination

  246. Using components: Amazon Redshift Destination

  247. Using components: Amazon Redshift Source

  248. Using components: Amazon Redshift Source

  249. Using components: Assert

  250. Using components: Assert Transformation

  251. Using components: Bing Ads Source

  252. Using Components: Bing Ads Source

  253. Using components: Clone

  254. Using components: Clone transformation

  255. Using components: Cross Join

  256. Using components: Cross Join Transformation

  257. Using components: Cube and Rollup

  258. Using components: Cube transformation

  259. Using components: Database Destination

  260. Using components: Database Destination

  261. Using components: Database Source

  262. Using components: Database Source

  263. Using components: Distinct

  264. Using components: Distinct Transformation

  265. Using Components: Facebook Ads Insights Source

  266. Using components: Facebook Ads Insights Source

  267. Using components: File Storage Destination

  268. Using components: File Storage Destination

  269. Using components: File Storage Source

  270. Using components: File Storage Source

  271. Using components: Filter

  272. Using components: Filter Transformation

  273. Using components: Google AdWords Source

  274. Using components: Google Adwords source

  275. Using Components: Google Analytics Source

  276. Using components: Google Analytics Source

  277. Using components: Google BigQuery Destination

  278. Using components: Google BigQuery Destination

  279. Using Components: Google BigQuery Source

  280. Using components: Google BigQuery Source

  281. Using components: Google Cloud Spanner Destination

  282. Using components: Google Cloud Spanner Source

  283. Using components: Google Cloud Spanner Source

  284. Using components: Google Spanner Destination

  285. Using components: Join

  286. Using components: Join Transformation

  287. Using components: Limit

  288. Using components: Limit Transformation

  289. Using components: MongoDB Destination

  290. Using components: MongoDB Destination

  291. Using components: MongoDB Source

  292. Using components: MongoDB Source

  293. Using components: NetSuite Source

  294. Using components: NetSuite Source

  295. Using components: Rank

  296. Using components: Rank Transformation

  297. Using Components: Rest API Destination

  298. Using Components: Rest API Source

  299. Using components: Rest API Source

  300. Using Components: Salesforce Destination

  301. Using components: Salesforce Destination

  302. Using Components: Salesforce Source

  303. Using components: Salesforce source

  304. Using components: Sample

  305. Using components: Sample Transformation

  306. Using components: Select

  307. Using components: Select Transformation

  308. Using components: Snowflake Destination

  309. Using components: Snowflake Destination

  310. Using components: Sort

  311. Using components: Sort Transformation

  312. Using components: Union

  313. Using components: Union Transformation

  314. Using Components: Window

  315. Using components: Window Transformation

  316. Using Expressions in Xplenty

  317. Using ISO 8601 string functions

  318. Using pattern-matching in source component paths

  319. UUID

  320. Validating a package

  321. Validating a package

  322. Viewing all jobs in the account

  323. Viewing and modifying your billing information and account usage

  324. Viewing and setting web and email notifications

  325. Viewing completed tasks outputs

  326. Viewing job error details for failed jobs

  327. Viewing jobs in a specific cluster

  328. WeeksBetween

  329. Working in the new package designer

  330. Working in the package designer

  331. XPath

  332. XPathToBag

  333. Xplenty Functions

  334. Xplenty Support Rates

  335. Xplenty terminology

  336. Xplenty's API

  337. Xplenty's clusters

  338. Xplenty's IP list

  339. Xplenty's packages

  340. xplenty_rb.bags_difference

  341. xplenty_rb.bags_intersect

  342. xplenty_rb.bags_union

  343. xplenty_rb.concat_bag

  344. xplenty_rb.transform

  345. xplenty_rb.transform_bag

  346. YearsBetween

Feedback and Knowledge Base