-
Sort Column in ETL?
I am trying to import some old Data and merge it with data from a connector but the data is in different orders. The legacy data went decending 1 2 3 4 but when I merge the data with the connector its adding to the top so I get 5 1 2 3 4 I was just wondering, is it possible to merge the data onto the bottom or sort the…
-
Beast Mode add output to input
I am trying to make the output of an ETL the same as the input, the idea is that this runs once a month and adds the month stats to itself, and just build up. However when I set the output to the same as the input it doesn't like it and renames it. How can I have one Dataset which I add data to ? Thanks
-
URI Encode
I am building a new connector and need to URI encode data. I have tried DOMO.b64EncodeUnicode(***) but this does not seem to work. Anyone got any ideas? Thanks
-
Unix Timestamp or epoch time in connector
Hi, I am trying to build a new connector where I need to add the unix_timestamp into the header. How do I get the epoch/unix timestamp? This is A string that contains the a long value that represents the current time in milliseconds since midnight, January 1, 1970 UTC. Thanks
-
converting code from Postman to Domo
I have managed to write a connector for Akamai however now need to convert it into Domo i.e. change variable names eg. is there any guide or tool for this as ther eare some parts Im not sure about i.e. where its making requests withi Postman that are obviously not relevant wihin Domo.
-
Connector provides data for multiple tables
I am creating a connector but the json I get back gives me data for multiple tables. I am currently parsing then magicparsing as the top level is called 'data' var jsonRes = JSON.parse(res); datagrid.magicParseJSON(jsonRes.data); { "data": [ { "key": "osTypes", "title": "OS", "values": [ { "count": 5098, "title":…
-
Compare to text lists and highlight difference
I have 2 lists and am trying to highlight differences i.e. Value owned Managed values value 1 Value 1 Value 2 Value 3 Value 3 I want to highlight Value 2 So far I have used ETL to generate a new dataset with just these 2 columns. I am then trying to use beastmode using something like NULLIF or a case when 'managed values'…
-
decode a base64 Key
I am trying to create an API connector where one of the steps requires me to decode a base64 Secret Key. This is then used to calculate the hash-based message authentication code (HMAC) of the Data To Sign using the HMAC-SHA1 algorithm! I have the following code to Sign the data using the HMAC-SHA1 algorithm but Dont have…
-
DataGrid Delete Rows
I have some JSON data I am pulling into Domo via a connector however when I Parse the data I end up with a table which has rows with varying numbers of coloumns and therefore wont save into a dataset. One option I am looking at is to just delete the rows I dont need and end up with one relevant row of the data Im after,…
-
Using Latest Batch ID or Batch date
I have seen complicated ways to just use the latest data within a dataset - and I couldnt understand how to set them up. does anyone have a simple way to just use the last batch data? Currently I am just filtering to BATCH_ID Greater or equal to and entering latest number, obviously when the batches run I then have a few…
-
Table heading down the side
Currently I have a number of values I am feeding into a table but the headings are along to top (columns). I sit possible to rotate the table so that all the headings are down the left side? i.e. Heading 1 Heading 2 Heading 3 Data 1 Data 2 Data 3 but I want Heading 1 Data 1 Heading 2 Data 2 Heading 3 Data 3 thanks
-
Dataset not storing
I have built a connector which will collect about 550 lines of data. Whwen I run this in the connector developer, and set it to 'Create/Update Dataset' it reports its created is and I have a success - however - when I go to the datasets it shows as 'storing' and is stuck there. I have deleted and started again but get the…
-
connector needs Date/time in yyyyMMddTHH:mm:ss+0000 format
Hi all, I am building another connector which needs date formatted <yyyyMMddTHH:mm:ss+0000> The year as a 4-digit decimal number including century, followed by the month as a decimal number with a range of 01–12, followed by the day of the month as a decimal number with a range of 01–31, followed by a character T, followed…
-
Get Current Date/time
I am trying to build a connector which needs the call to include the date and time in the header.. Date / Time (x-mc-date) The x-mc-date header must be created in the following format: Tue, 24 Nov 2015 12:50:11 GMT Any ideas how I can get the current date and time and then also in this format? Thanks
-
MagicParseJSON skip header
I have managed to authenticate an API and am getting JSON data however due to the fact that it has a header, magicparse puts all the data onto one long row. Is there a way to skip the overarching title below of "data": because the first column I want is Volume…
-
Adding totals based on titles
hi, I am trying to group together user totals based on their adjacent column title I have tried groups and cases but cant get this to work. My latest attempt is below, can anyone help. SUM( CASE when `PS Variable Stub`="ADenabled" or `PS Variable Stub`="O365enabled" then `GUID_ User Count` else 0 End ) Thanks
-
Azure connector resources
I have built an Azure connector but I am trying to get the O365 Security Score. Dont have a clue what Datasets "subscription ID" and "Resource Group Name" are.