Log In

Log In



Not registered yet?


Reset password Activation link

Forums ~ REST API

Extracting, filtering and removing records using the REST API
November 22, 2017
Completed
0
 

dave@dlsys.net
November 22, 2017

Hello – I would like to an SSIS C# script component to extract form data, on a daily basis using the JSON REST API. How would you suggest retrieving only the new new records added since the previous extract? Is there a way to filter the records? How can I remove the records retrieved in bulk? Do you have any code examples?

Thank you!

Davie



Igor Petrushenko
November 22, 2017

Hi, Davie!

>>How would you suggest retrieving only the new new records added since the previous extract?

MTH do not know about your extract time. So you have to remember it yourself somehow. Either by fetching data from Reports or saving last extract info in some MTH cell.

>>Is there a way to filter the records?

Yes, it’s called Reports. You filter records by running Search and can save results as a Report.

Please, notice that you can enable the system ‘Created at’ and ‘Updated at’ columns on the ‘Fields’ menu (in the Advanced settings at the bottom).
This way you’ll be able to run Search using the timestamp columns. Or you can have your own timestamp columns.
Having such reports can help you with determining which records to fetch Today.

>>How can I remove the records retrieved in bulk?

Currently there is no Bulk Delete operation in API. If this is the roadblock for you we can further discuss and add such feature.

>>Do you have any code examples?

There is Ruby and JavaScript examples available on the API page.

Hope it helps!

Please, let me know if you’ll have any other questions.



Igor Petrushenko
November 22, 2017

I’ve noticed in logs that you doing request like this:

“entities?rest_api_key=API_KEY/?database_name=JDSweb/?form_name=Assistance_Request_Form”

It should be:
“entities.json?rest_api_key=API_KEY&database_name=JDSweb&form_name=Assistance_Request_Form”



dave@dlsys.net
November 22, 2017

It works. I don’t know what I am doing. I was just guessing the syntax. Thanks Igor.



Igor Petrushenko
November 22, 2017

Great!
Please, feel free to contact us at any time if you’ll have any questions.



Reply:

File attachment (max 10MB)




Share the discussion in the social networks:





Tags

#Android

#CSV

#Can't be blank

#Excel

#Export

#Google

#HIPAA Compliance

#HTML

#IP

#Import

#Mobile

#PCI compliant

#QuintaDB

#SMS

#URL

#access rights

#account

#actions

#activation

#activity

#advanced options

#api

#attach

#autocomplete

#autoincrement

#background

#backup

#birthday

#blocked

#boolean

#browser

#button

#calendar

#captcha

#chart

#checkbox

#clone

#close the form

#cms

#color

#column

#conditional formatting

#confirm

#constant

#cookies

#country

#crm

#css

#custom

#data security

#database

#date

#date & time

#date format

#description

#dropdown

#dublicate

#duplicate

#dynamic form

#email

#example

#extract

#field

#field names

#field type

#file

#file upload

#filter

#font

#form

#form builder

#formatting

#formula

#forum

#free

#ftp

#gap

#geolocation

#grouping

#horizontal

#id

#iframe

#images

#in-place editing

#instruction

#integration

#invite

#java

#js

#language

#limits

#link forms

#links

#location

#log

#login

#logo

#map

#mc access

#members

#moved form

#moved project

#ms access

#multiline field

#multipage form

#multiple

#multiple forms

#mysql

#new features

#new window

#newsletter

#not empty

#notification

#number field

#number of records per page

#number separator

#numbered column

#offer

#offline

#operand

#page break

#partnership form

#password

#payment

#pdf

#phone number

#plan

#popup

#portal

#position

#print

#quotation tool

#radio button

#records

#redirect

#referral program

#registration

#regular expressions

#relationship

#remind

#remove

#rename

#report

#rules

#script

#scroll

#search

#security data

#security menu

#server

#service

#sheets

#show/hide

#side by side

#signature

#size

#sort

#special character

#state

#storage

#subscribe

#suggestion

#support

#table

#team

#template

#text

#text direction

#time

#total

#trial

#tutorial

#two-column

#update column

#update records

#updates

#upload file

#users

#validation

#video

#view

#widget

#window

#wysiwyg

#youtube

#zip code