-
Relative date range filtering using JSON no code with API only supporting timestamp format
Hello, I'd like to use our partner API within Domo with JSON no code connector The connexion works fine until I set up a relative date range filtering of 7 days (which is allowed by the API with startDate and endDate parameters). The API documentation specifies that date parameters should follow this timestamp format :…
-
No Code JSON Connector - help
Hi DOMO Gods, I've recently set up a NO code JSON connector to pull an endpoint from a CRM that we use. I worked with a DOMO consult to configure the pagination and parsing, so that we were able to get the data we wanted and it worked well for a few days, however I'm getting the following error message now for the last few…
-
Json No Code Connector - Question.
Hello Everyone, I am using Json No Code Connector to pull the data in the Replace mode. I would like to only replace data which is changed at the backend and not the whole data. Is there a way we can do this in Connector settings ? Or any other way ? Thanks,
-
Use JSON Advanced Connector to POST to an API
Hi there, has anyone successfully got the JSON advanced connector to POST to an API, when using JSON data as parameters in a request body? I've got a call working in Postman ok, but when I transfer it to DOMO I get an error: "Domo is ready, but the credentials you entered are invalid. Verify your account credentials and…
-
How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Question: Is it possible to execute command line interface tool operations within Python, specifically the 'list-dataflow' command? Elaboration: The 'list-dataflow' command in the command line interface tool returns JSON structured metadata for a dataflow. My guess is that this command is just making a GET request to a…
-
DataFlow Transform (i.e. Action) Types in API JSON data
My question: What factors determine the type of a dataflow transform in the api JSON data (e.g. GenerateTableAction, SQL, SqlAction)? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a…
-
Timestamp Convention in JSON File from Command Line DataFlow Request
My question: Does anyone know DOMO's timestamp convention and how these map to normal timing conventions? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a filepath returns a json file to…
-
Domo User Name
Hello, maybe a silly question domo.env.userId This line gets the id for a Domo User, but how can I get the User Name?I'm recreating DP19 Advanced App Building Exercise and I'd like my app to have the username instead of the id, this will be helpful for when I create custom apps for my company Thanks in advance
-
Amazon DynamoDB Data ETL
My team recently began to transition one of our key source data systems to be housed on AWS DynamoDB. Our connection to the legacy system is cumbersome to say the least (e.g. use a custom powershell script, workbench, and csv to feed data to Domo)...So, I was excited to utilize one of Domo's API Connectors to DynamoDB,…
-
JSON with custom parsing pagination
I have a question regarding the JSON with custom parsing connector. I have a dataset using the pagination settings to find the next page based (I think) on the ID of the last row returned. If I set this dataset up for a regular refresh, will it look at the last ID in the dataset, or would it just restart from the…
-
JSON No Code - Parse Issue
I'm connecting to Parallax API, but am running into Parsing issues. When I go to the parse section of the JSON Connector, I am able to fully parse out the data into the necessary format that I need, but when I run the connector there is a column that won't parse. In the preview the data looks like this: Pre-parse:…