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

  84. Defining connections

  85. DeviceFamily

  86. DistInMilesHaversine

  87. Editing and scaling clusters

  88. Email Hooks

  89. Encrypt

  90. ExecuteBQInsert

  91. ExecuteSqlBoolean

  92. ExecuteSqlDateTime

  93. ExecuteSqlDouble

  94. ExecuteSqlFloat

  95. ExecuteSqlInt

  96. ExecuteSqlLong

  97. ExecuteSqlNonQuery

  98. ExecuteSqlString

  99. EXP

  100. ExtractQueryStringParam

  101. ExtractSearchQuery

  102. ExtractUABrowserID

  103. ExtractUABrowserName

  104. ExtractUrlPart

  105. Flatten

  106. FLOOR

  107. GetBytes

  108. GetDay

  109. GetHour

  110. GetMilliSecond

  111. GetMinute

  112. GetMonth

  113. GetSecond

  114. Getting Started

  115. GetWeek

  116. GetWeekYear

  117. GetYear

  118. HipChat Hooks

  119. HoursBetween

  120. How Do I Encrypt and Decrypt sensitive data

  121. How Do I Move data incrementally between databases

  122. How Do I Process JSON data

  123. How Do I Read data from file storage incrementally

  124. How do I select my file input format

  125. How Do I Work with Datetime Data

  126. How to create a delivery

  127. INDEXOF

  128. IntervalIntersection

  129. IsBase64

  130. IsEmpty

  131. IsISODatetime

  132. ISOAddDuration

  133. ISODatetimeToString

  134. ISODatetimeToTimestampFormat

  135. ISOSubtractDuration

  136. ISOToDay

  137. ISOToHour

  138. ISOToMinute

  139. ISOToMonth

  140. ISOToSecond

  141. ISOToWeek

  142. ISOToYear

  143. JsonExtract

  144. JsonExtractScalar

  145. JsonStringToBag

  146. JsonStringToMap

  147. LAST_INDEX_OF

  148. LatitudeFromIP

  149. LCFIRST

  150. Length

  151. List of Salesforce objects

  152. LOG

  153. LOG10

  154. LongitudeFromIP

  155. LOWER

  156. Managing your account settings

  157. Managing your SSH keys

  158. Managing your Xplenty account members

  159. MapToBag

  160. MapToQueryString

  161. MD2

  162. MD5

  163. MilliSecondsBetween

  164. MinutesBetween

  165. Modifying your personal settings

  166. Monitoring clusters

  167. Monitoring jobs

  168. MonthsBetween

  169. OsFamily

  170. OsFullName

  171. OsMajor

  172. OsMinor

  173. OsPatch

  174. OsPatchMinor

  175. OsVersion

  176. PagerDuty Hooks

  177. ParseDate

  178. ParseDoubleOrDefault

  179. ParseFloatOrDefault

  180. ParseIntOrDefault

  181. ParseLongOrDefault

  182. PlatformFamily

  183. POW

  184. QueryStringToMap

  185. RANDOM

  186. REGEX_EXTRACT

  187. REGEX_EXTRACT_ALL

  188. REGEX_FIND_ALL

  189. RegionCodeFromIP

  190. RegionNameFromIP

  191. REPLACE

  192. Reverse

  193. ROUND

  194. ROUND_TO

  195. Running jobs

  196. Scheduling Package Execution

  197. SecondsBetween

  198. Selecting a plan

  199. Selecting the account to work in

  200. Service Hooks

  201. Set up a reverse SSH tunnel from Windows

  202. Setting account member roles

  203. SHA1

  204. SHA256

  205. SHA256WithRSA

  206. SHA384

  207. SHA512

  208. Signing out from Xplenty

  209. SIN

  210. SINH

  211. SIZE

  212. Slack Hooks

  213. Sleep

  214. SPRINTF

  215. SQRT

  216. StringToISODatetime

  217. STRSPLIT

  218. STRSPLITTOBAG

  219. SUBSTRING

  220. SubtractDuration

  221. SwitchTimeZone

  222. System and pre-defined variables

  223. TAN

  224. TANH

  225. Terminating a cluster

  226. TimestampFormatToISODatetime

  227. To view job progress details

  228. TOBAG

  229. ToDate

  230. ToDateCustomFormats

  231. ToHexString

  232. ToJson

  233. TOKENIZE

  234. TOMAP

  235. ToMilliSeconds

  236. ToString

  237. TOTUPLE

  238. ToUnixTime

  239. TRIM

  240. UCFIRST

  241. UPPER

  242. URLDecode

  243. URLEncode

  244. Using and setting variables in your packages

  245. Using components: Aggregate

  246. Using components: Aggregate Transformation

  247. Using components: Amazon Redshift Destination

  248. Using components: Amazon Redshift Destination

  249. Using components: Amazon Redshift Source

  250. Using components: Amazon Redshift Source

  251. Using components: Assert

  252. Using components: Assert Transformation

  253. Using components: Bing Ads Source

  254. Using Components: Bing Ads Source

  255. Using components: Clone

  256. Using components: Clone transformation

  257. Using components: Cross Join

  258. Using components: Cross Join Transformation

  259. Using components: Cube and Rollup

  260. Using components: Cube transformation

  261. Using components: Database Destination

  262. Using components: Database Destination

  263. Using components: Database Source

  264. Using components: Database Source

  265. Using components: Distinct

  266. Using components: Distinct Transformation

  267. Using Components: Facebook Ads Insights Source

  268. Using components: Facebook Ads Insights Source

  269. Using components: File Storage Destination

  270. Using components: File Storage Destination

  271. Using components: File Storage Source

  272. Using components: File Storage Source

  273. Using components: Filter

  274. Using components: Filter Transformation

  275. Using components: Google AdWords Source

  276. Using components: Google Adwords source

  277. Using Components: Google Analytics Source

  278. Using components: Google Analytics Source

  279. Using components: Google BigQuery Destination

  280. Using components: Google BigQuery Destination

  281. Using Components: Google BigQuery Source

  282. Using components: Google BigQuery Source

  283. Using components: Google Cloud Spanner Destination

  284. Using components: Google Cloud Spanner Source

  285. Using components: Google Cloud Spanner Source

  286. Using components: Google Spanner Destination

  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 Destination

  299. Using Components: Rest API Source

  300. Using components: Rest API Source

  301. Using Components: Salesforce Destination

  302. Using components: Salesforce Destination

  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 Transformation

  313. Using Components: Window

  314. Using components: Window Transformation

  315. Using Expressions in Xplenty

  316. Using ISO 8601 string functions

  317. Using pattern-matching in source component paths

  318. UUID

  319. Validating a package

  320. Validating a package

  321. Viewing all jobs in the account

  322. Viewing and modifying your billing information and account usage

  323. Viewing and setting web and email notifications

  324. Viewing completed tasks outputs

  325. Viewing job error details for failed jobs

  326. Viewing jobs in a specific cluster

  327. WeeksBetween

  328. Working in the new package designer

  329. Working in the package designer

  330. XPath

  331. XPathToBag

  332. Xplenty Functions

  333. Xplenty Support Rates

  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