Skip to content

Instantly share code, notes, and snippets.

View sugimomoto's full-sized avatar

Kazuya Sugimoto sugimomoto

View GitHub Profile
@sugimomoto
sugimomoto / datetimeformatter.swift
Created December 21, 2020 11:39
Datetime Formatter for Swift
import UIKit
/*
Date型から任意のフォーマットで文字列を生成する場合
*/
// Reference
// https://developer.apple.com/documentation/foundation/dateformatter
var date = Date()
@sugimomoto
sugimomoto / ZoomReplication.ps1
Created October 23, 2020 03:37
ZoomReplication
# ライブラリ読み込み
[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 August 13, 2020 15:32
Postman Collection for KING OF TIME API
{
"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": {
@sugimomoto
sugimomoto / SampleJRuby.rb
Created July 3, 2020 06:38
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 05:39
Collabofloc コラボフローの申請フォームで SQL Server のマスタデータを参照する:CData API Server連携
(function () {
'use strict';
// オートコンプリートの設定フィールド
const AutocompleteSetting =
{
// 商品名:オートコンプリートの対象フィールド
InputName: 'fid12',
// 明細行数
@sugimomoto
sugimomoto / Issue.cs
Created May 10, 2020 02:30
BacklogAPIRequestSample
using System;
using System.Collections.Generic;
using System.Text;
namespace BacklogAPI
{
public class Issue
{
public int id { get; set; }
@sugimomoto
sugimomoto / BacklogAPIRequestSample.cs
Created May 10, 2020 02:30
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 08:19
board API SampleConsoleApp
using Newtonsoft.Json;
using RestSharp;
using System;
namespace boardSampleConsoleApp
{
class Program
{
static void Main(string[] args)
{
@sugimomoto
sugimomoto / zaico.json
Created April 3, 2020 13:34
ZAICO API Postman Collection
{
"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": {
{
"text": "My added comments to this Tweet ---> https:\/\/t.co\/LinkToTweet",
"user": {
"screen_name": "TweetQuoter"
},
"quoted_status": {
"text": "original message",
"user": {
"screen_name": "OriginalTweeter"
},