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 (Beta)

  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 Pinterest

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

  23. Allowing Xplenty access to my data on Shopify

  24. Allowing Xplenty access to my data on Xero

  25. Allowing Xplenty access to my data on Xero (Beta)

  26. Allowing Xplenty access to my data on YouTube

  27. Allowing Xplenty access to my Google BigQuery dataset

  28. Allowing Xplenty access to my Redshift cluster

  29. Allowing Xplenty access to my server behind a firewall

  30. Allowing Xplenty access to my Snowflake account

  31. Allowing Xplenty access to NetSuite

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

  33. API Endpoints with pagination support

  34. ASIN

  35. ATAN

  36. BagToString

  37. BagToTuple

  38. Base64Decode

  39. Base64DecodeToString

  40. Base64Encode

  41. Base64EncodeToString

  42. BinaryCCurl

  43. BinaryCurl

  44. BrowserFamily

  45. BrowserFullName

  46. BrowserMajor

  47. BrowserMinor

  48. BrowserPatch

  49. BrowserVersion

  50. ByteArrayToString

  51. CBRT

  52. CCurl

  53. CCurlPoll

  54. CCurlWithPagination

  55. CEIL

  56. Changing your password

  57. CityNameFromIP

  58. ClockTime

  59. COALESCE

  60. CONCAT

  61. ContinentCodeFromIP

  62. ContinentNameFromIP

  63. COS

  64. COSH

  65. CountryCodeFromIP

  66. CountryNameFromIP

  67. Create a package from a template

  68. Creating a cluster

  69. Creating a new package

  70. Creating a new package in New Xplenty

  71. Creating a workflow

  72. CSVSPLIT

  73. Curl

  74. CurlPoll

  75. CurlWithPagination

  76. CurrentTime

  77. DateDiffDays

  78. DateDiffHours

  79. DateDiffMinutes

  80. DateDiffMonths

  81. DateDiffSeconds

  82. DateDiffYears

  83. DaysBetween

  84. Defining connections

  85. DeviceFamily

  86. DistInMilesHaversine

  87. Editing and scaling clusters

  88. Email Hooks

  89. ExecuteBQInsert

  90. ExecuteSqlBoolean

  91. ExecuteSqlDateTime

  92. ExecuteSqlDouble

  93. ExecuteSqlFloat

  94. ExecuteSqlInt

  95. ExecuteSqlLong

  96. ExecuteSqlNonQuery

  97. ExecuteSqlString

  98. EXP

  99. ExtractQueryStringParam

  100. ExtractSearchQuery

  101. ExtractUABrowserID

  102. ExtractUABrowserName

  103. ExtractUrlPart

  104. Flatten

  105. FLOOR

  106. GetBytes

  107. GetDay

  108. GetHour

  109. GetMilliSecond

  110. GetMinute

  111. GetMonth

  112. GetSecond

  113. Getting Started

  114. GetWeek

  115. GetWeekYear

  116. GetYear

  117. HipChat Hooks

  118. HoursBetween

  119. How Do I Move data incrementally between databases

  120. How Do I Process JSON data

  121. How Do I Read data from file storage incrementally

  122. How do I select my file input format

  123. How Do I Work with Datetime Data

  124. How to create a delivery

  125. Importing Heroku Connections

  126. INDEXOF

  127. IntervalIntersection

  128. IsBase64

  129. IsEmpty

  130. IsISODatetime

  131. ISOAddDuration

  132. ISODatetimeToString

  133. ISODatetimeToTimestampFormat

  134. ISOSubtractDuration

  135. ISOToDay

  136. ISOToHour

  137. ISOToMinute

  138. ISOToMonth

  139. ISOToSecond

  140. ISOToWeek

  141. ISOToYear

  142. JsonExtract

  143. JsonExtractScalar

  144. JsonStringToBag

  145. JsonStringToMap

  146. LAST_INDEX_OF

  147. LatitudeFromIP

  148. LCFIRST

  149. Length

  150. List of Salesforce objects

  151. LOG

  152. LOG10

  153. LongitudeFromIP

  154. LOWER

  155. Managing your account settings

  156. Managing your SSH keys

  157. Managing your Xplenty account members

  158. MapToBag

  159. MapToQueryString

  160. MD2

  161. MD5

  162. MilliSecondsBetween

  163. MinutesBetween

  164. Modifying your personal settings

  165. Monitoring clusters

  166. Monitoring jobs

  167. MonthsBetween

  168. OsFamily

  169. OsFullName

  170. OsMajor

  171. OsMinor

  172. OsPatch

  173. OsPatchMinor

  174. OsVersion

  175. PagerDuty Hooks

  176. ParseDate

  177. ParseDoubleOrDefault

  178. ParseFloatOrDefault

  179. ParseIntOrDefault

  180. ParseLongOrDefault

  181. PlatformFamily

  182. POW

  183. QueryStringToMap

  184. RANDOM

  185. REGEX_EXTRACT

  186. REGEX_EXTRACT_ALL

  187. REGEX_FIND_ALL

  188. RegionCodeFromIP

  189. RegionNameFromIP

  190. REPLACE

  191. Reverse

  192. ROUND

  193. ROUND_TO

  194. Running jobs

  195. Scheduling Package Execution

  196. SecondsBetween

  197. Selecting a plan

  198. Selecting the account to work in

  199. Service Hooks

  200. Set up a reverse SSH tunnel from Windows

  201. Setting account member roles

  202. SHA1

  203. SHA256

  204. SHA256WithRSA

  205. SHA384

  206. SHA512

  207. Signing out from Xplenty

  208. SIN

  209. SINH

  210. SIZE

  211. Slack Hooks

  212. Sleep

  213. SPRINTF

  214. SQRT

  215. StringToISODatetime

  216. STRSPLIT

  217. STRSPLITTOBAG

  218. SUBSTRING

  219. SubtractDuration

  220. SwitchTimeZone

  221. System and pre-defined variables

  222. TAN

  223. TANH

  224. Terminating a cluster

  225. TimestampFormatToISODatetime

  226. To view job progress details

  227. TOBAG

  228. ToDate

  229. ToDateCustomFormats

  230. ToHexString

  231. ToJson

  232. TOKENIZE

  233. TOMAP

  234. ToMilliSeconds

  235. ToString

  236. TOTUPLE

  237. ToUnixTime

  238. TRIM

  239. UCFIRST

  240. UPPER

  241. URLDecode

  242. URLEncode

  243. Using and setting variables in your packages

  244. Using components: Aggregate

  245. Using components: Aggregate Transformation

  246. Using components: Amazon Redshift Destination

  247. Using components: Amazon Redshift Destination

  248. Using components: Amazon Redshift Source

  249. Using components: Amazon Redshift Source

  250. Using components: Assert

  251. Using components: Assert Transformation

  252. Using components: Bing Ads Source

  253. Using Components: Bing Ads Source

  254. Using components: Clone

  255. Using components: Clone transformation

  256. Using components: Cross Join

  257. Using components: Cross Join Transformation

  258. Using components: Cube and Rollup

  259. Using components: Cube transformation

  260. Using components: Database Destination

  261. Using components: Database Destination

  262. Using components: Database Source

  263. Using components: Database Source

  264. Using components: Distinct

  265. Using components: Distinct Transformation

  266. Using components: Facebook Ads Insights Source

  267. Using Components: Facebook Ads Insights Source (Beta)

  268. Using components: File Storage Destination

  269. Using components: File Storage Destination

  270. Using components: File Storage Source

  271. Using components: File Storage Source

  272. Using components: Filter

  273. Using components: Filter Transformation

  274. Using components: Google AdWords Source

  275. Using components: Google Adwords source

  276. Using Components: Google Analytics Source

  277. Using components: Google Analytics Source

  278. Using components: Google BigQuery Destination

  279. Using components: Google BigQuery Destination

  280. Using Components: Google BigQuery Source

  281. Using components: Google BigQuery Source

  282. Using components: Google Cloud Spanner Destination

  283. Using components: Google Cloud Spanner Source

  284. Using components: Google Cloud Spanner Source

  285. Using components: Google Spanner Destination

  286. Using components: Join

  287. Using components: Join Transformation

  288. Using components: Limit

  289. Using components: Limit Transformation

  290. Using components: MongoDB Destination

  291. Using components: MongoDB Destination

  292. Using components: MongoDB Source

  293. Using components: MongoDB Source

  294. Using components: NetSuite Source

  295. Using components: NetSuite Source

  296. Using components: Rank

  297. Using components: Rank Transformation

  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 (beta)

  309. Using components: Snowflake Destination (beta)

  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 terminology

  335. Xplenty's API

  336. Xplenty's clusters

  337. Xplenty's IP list

  338. Xplenty's packages

  339. xplenty_rb.bags_difference

  340. xplenty_rb.bags_intersect

  341. xplenty_rb.bags_union

  342. xplenty_rb.concat_bag

  343. xplenty_rb.transform

  344. xplenty_rb.transform_bag

  345. YearsBetween

Feedback and Knowledge Base