Skip to content

Instantly share code, notes, and snippets.

Avatar

Kazuya Sugimoto sugimomoto

View GitHub Profile
View ZoomReplication.ps1
# ライブラリ読み込み
[void][System.Reflection.Assembly]::LoadWithPartialName("System.Data")
# DB接続
$connectionString = "DSN=CData API Zoom;"
$odbcCon = New-Object System.Data.Odbc.OdbcConnection($connectionString)
$odbcCon.Open()
# コマンドオブジェクト作成
$odbcCmd = New-Object System.Data.Odbc.OdbcCommand
@sugimomoto
sugimomoto / KING OF TIME.postman_collection.json
Created Aug 13, 2020
Postman Collection for KING OF TIME API
View KING OF TIME.postman_collection.json
{
"info": {
"_postman_id": "56c4abe2-794a-4136-bbe7-c6313f0c2140",
"name": "KING OF TIME",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "企業情報データを取得",
"request": {
View SampleJRuby.rb
require 'java'
require 'rubygems'
# CData Salesforce JDBC Driver のjarファイルパスを指定
require "C:/Program Files/CData/CData JDBC Driver for Salesforce 2019J/lib/cdata.jdbc.salesforce.jar"
# Salesforce への接続文字列を設定
url = "jdbc:salesforce:User=XXXX;Password=XXXX;Security Token=XXXX;"
conn = java.sql.DriverManager.getConnection(url)
stmt = conn.createStatement
@sugimomoto
sugimomoto / CDataAPIServerAutocomplete.js
Last active May 26, 2020
Collabofloc コラボフローの申請フォームで SQL Server のマスタデータを参照する:CData API Server連携
View CDataAPIServerAutocomplete.js
(function () {
'use strict';
// オートコンプリートの設定フィールド
const AutocompleteSetting =
{
// 商品名:オートコンプリートの対象フィールド
InputName: 'fid12',
// 明細行数
@sugimomoto
sugimomoto / Issue.cs
Created May 10, 2020
BacklogAPIRequestSample
View Issue.cs
using System;
using System.Collections.Generic;
using System.Text;
namespace BacklogAPI
{
public class Issue
{
public int id { get; set; }
View BacklogAPIRequestSample.cs
using Newtonsoft.Json;
using RestSharp;
using System;
namespace BacklogAPI
{
class Program
{
static void Main(string[] args)
{
@sugimomoto
sugimomoto / boardSampleConsoleApp.cs
Created May 3, 2020
board API SampleConsoleApp
View boardSampleConsoleApp.cs
using Newtonsoft.Json;
using RestSharp;
using System;
namespace boardSampleConsoleApp
{
class Program
{
static void Main(string[] args)
{
@sugimomoto
sugimomoto / zaico.json
Created Apr 3, 2020
ZAICO API Postman Collection
View zaico.json
{
"info": {
"_postman_id": "a49944d1-5a6c-4017-9e8b-0f8b09d48eb0",
"name": "ZAICO",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "在庫データ一覧取得",
"request": {
View gist:951394752579c255f7ca7702f38ceeb5
{
"text": "My added comments to this Tweet ---> https:\/\/t.co\/LinkToTweet",
"user": {
"screen_name": "TweetQuoter"
},
"quoted_status": {
"text": "original message",
"user": {
"screen_name": "OriginalTweeter"
},
@sugimomoto
sugimomoto / SQLServerSample.cs
Last active Feb 7, 2020
CData.SqlKata.SQLServerSample
View SQLServerSample.cs
using System;
using SqlKata;
using SqlKata.Execution;
using SqlKata.Compilers;
using System.Data.SqlClient;
namespace CData.SqlKata.CDataSampleProject
{
class Program
{
You can’t perform that action at this time.