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

  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. GetWeek

  113. GetWeekYear

  114. GetYear

  115. HipChat Hooks

  116. HoursBetween

  117. How Do I Move data incrementally between databases

  118. How Do I Process JSON data

  119. How Do I Read data from S3 incrementally

  120. How do I select my file input format

  121. How Do I Work with Datetime Data

  122. How to create a delivery

  123. Importing Heroku Connections

  124. INDEXOF

  125. IntervalIntersection

  126. IsBase64

  127. IsEmpty

  128. IsISODatetime

  129. ISOAddDuration

  130. ISODatetimeToString

  131. ISODatetimeToTimestampFormat

  132. ISOSubtractDuration

  133. ISOToDay

  134. ISOToHour

  135. ISOToMinute

  136. ISOToMonth

  137. ISOToSecond

  138. ISOToWeek

  139. ISOToYear

  140. JsonExtract

  141. JsonExtractScalar

  142. JsonStringToBag

  143. JsonStringToMap

  144. LAST_INDEX_OF

  145. LatitudeFromIP

  146. LCFIRST

  147. Length

  148. List of Salesforce objects

  149. LOG

  150. LOG10

  151. LongitudeFromIP

  152. LOWER

  153. Managing your account settings

  154. Managing your SSH keys

  155. Managing your Xplenty account members

  156. MapToBag

  157. MapToQueryString

  158. MD2

  159. MD5

  160. MilliSecondsBetween

  161. MinutesBetween

  162. Modifying your personal settings

  163. Monitoring clusters

  164. Monitoring jobs

  165. MonthsBetween

  166. OsFamily

  167. OsFullName

  168. OsMajor

  169. OsMinor

  170. OsPatch

  171. OsPatchMinor

  172. OsVersion

  173. PagerDuty Hooks

  174. ParseDate

  175. ParseDoubleOrDefault

  176. ParseFloatOrDefault

  177. ParseIntOrDefault

  178. ParseLongOrDefault

  179. PlatformFamily

  180. POW

  181. QueryStringToMap

  182. RANDOM

  183. REGEX_EXTRACT

  184. REGEX_EXTRACT_ALL

  185. REGEX_FIND_ALL

  186. RegionCodeFromIP

  187. RegionNameFromIP

  188. REPLACE

  189. Reverse

  190. ROUND

  191. ROUND_TO

  192. Running jobs

  193. Scheduling Package Execution

  194. SecondsBetween

  195. Selecting a plan

  196. Selecting the account to work in

  197. Service Hooks

  198. Set up a reverse SSH tunnel from Windows

  199. Setting account member roles

  200. SHA1

  201. SHA256

  202. SHA256WithRSA

  203. SHA384

  204. SHA512

  205. Signing out from Xplenty

  206. SIN

  207. SINH

  208. SIZE

  209. Slack Hooks

  210. Sleep

  211. SPRINTF

  212. SQRT

  213. StringToISODatetime

  214. STRSPLIT

  215. STRSPLITTOBAG

  216. SUBSTRING

  217. SubtractDuration

  218. SwitchTimeZone

  219. System and pre-defined variables

  220. TAN

  221. TANH

  222. Terminating a cluster

  223. TimestampFormatToISODatetime

  224. To view job progress details

  225. TOBAG

  226. ToDate

  227. ToDateCustomFormats

  228. ToHexString

  229. ToJson

  230. TOKENIZE

  231. TOMAP

  232. ToMilliSeconds

  233. ToString

  234. TOTUPLE

  235. ToUnixTime

  236. TRIM

  237. UCFIRST

  238. UPPER

  239. URLDecode

  240. URLEncode

  241. Using and setting variables in your packages

  242. Using components: Aggregate

  243. Using components: Aggregate Transformation

  244. Using components: Amazon Redshift Destination

  245. Using components: Amazon Redshift Destination

  246. Using components: Amazon Redshift Source

  247. Using components: Amazon Redshift Source

  248. Using components: Assert

  249. Using components: Assert Transformation

  250. Using components: Bing Ads Source

  251. Using Components: Bing Ads Source

  252. Using components: Clone

  253. Using components: Clone transformation

  254. Using components: Cross Join

  255. Using components: Cross Join Transformation

  256. Using components: Cube and Rollup

  257. Using components: Database Destination

  258. Using components: Database Destination

  259. Using components: Database Source

  260. Using components: Database Source

  261. Using components: Distinct

  262. Using components: Distinct Transformation

  263. Using components: Facebook Ads Insights Source

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

  265. Using components: File Storage Destination

  266. Using components: File Storage Destination

  267. Using components: File Storage Source

  268. Using components: File Storage Source

  269. Using components: Filter

  270. Using components: Filter Transformation

  271. Using components: Google AdWords Source

  272. Using components: Google Adwords source

  273. Using Components: Google Analytics Source

  274. Using components: Google Analytics Source

  275. Using components: Google BigQuery Destination

  276. Using components: Google BigQuery Destination

  277. Using Components: Google BigQuery Source

  278. Using components: Google BigQuery Source

  279. Using components: Google Cloud Spanner Destination

  280. Using components: Google Cloud Spanner Source

  281. Using components: Google Cloud Spanner Source

  282. Using components: Google Spanner Destination

  283. Using components: Join

  284. Using components: Join Transformation

  285. Using components: Limit

  286. Using components: Limit Transformation

  287. Using components: MongoDB Destination

  288. Using components: MongoDB Destination

  289. Using components: MongoDB Source

  290. Using components: MongoDB Source

  291. Using components: NetSuite Source

  292. Using components: NetSuite Source

  293. Using components: Rank

  294. Using components: Rank Transformation

  295. Using Components: Rest API Source

  296. Using components: Rest API Source

  297. Using Components: Salesforce Destination

  298. Using components: Salesforce Destination

  299. Using Components: Salesforce Source

  300. Using components: Salesforce source

  301. Using components: Sample

  302. Using components: Sample Transformation

  303. Using components: Select

  304. Using components: Select Transformation

  305. Using components: Snowflake Destination (beta)

  306. Using components: Snowflake Destination (beta)

  307. Using components: Sort

  308. Using components: Sort Transformation

  309. Using components: Union

  310. Using components: Union Transformation

  311. Using Components: Window

  312. Using components: Window Transformation

  313. Using Expressions in Xplenty

  314. Using ISO 8601 string functions

  315. Using pattern-matching in source component paths

  316. UUID

  317. Validating a package

  318. Validating a package

  319. Viewing all jobs in the account

  320. Viewing and modifying your billing information and account usage

  321. Viewing and setting web and email notifications

  322. Viewing completed tasks outputs

  323. Viewing job error details for failed jobs

  324. Viewing jobs in a specific cluster

  325. WeeksBetween

  326. Working in the new package designer

  327. Working in the package designer

  328. XPath

  329. XPathToBag

  330. Xplenty Functions

  331. Xplenty terminology

  332. Xplenty's API

  333. Xplenty's clusters

  334. Xplenty's IP list

  335. Xplenty's packages

  336. xplenty_rb.bags_difference

  337. xplenty_rb.bags_intersect

  338. xplenty_rb.bags_union

  339. xplenty_rb.concat_bag

  340. xplenty_rb.transform

  341. xplenty_rb.transform_bag

  342. YearsBetween

Feedback and Knowledge Base